Modify excel database

J

Joao Saraiva

Good night !

I wonder if someone can help me or to tell me how to do this operation



- I have a database in excl where the basic product definition and
its features can be found in column A and the different products in stock
can be found in the following columns.



- The database is reasonably big (80 rows corresponding to the
different features describing the product and 70 columns corresponding to
the products in stock



- I would like to modify the database (without new data entry !) in
a way where the information is presented the other way around i.e. each row
corresponds to one product and each immediate following cell on the right
contains one of the product features.



I hope I managed to make myself clear.



I was hoping to get the help of some excel expert in the group . I only know
the basic functions !



Many thanks

JS
 
J

Joao Saraiva

Just to clarify .. the database looks like this


COLUMN A COLUMN B COLUMN C .......

Product ABC DEF
Manufacturer B&Co B&Co
Price 100 120
Production time 10 14
................
..................
.................

Thanks for your patience !
 
D

Dave Peterson

I would insert a new worksheet.

The select the range (80 rows by 70 columns) on the original sheet.
Edit|copy
then go to A1 of the new worksheet
edit|paste special|click the transpose button.

======
Each of these sheets are independent of the other. If you change something in
sheet1, sheet2 won't automatically.
 
D

dbahooker

you dont have a database in excel
i wish excel 'spoke database'

spit on anyone that uses excel ever for anything


-Aaron
 
J

Joao Saraiva

Nice posting ! Thanks !
You must feel really happy with it ... congratulations
 
Top