Modify database

  • Thread starter Thread starter Joao Saraiva
  • Start date Start date
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
 
just to sure if my understand is correct Joao,

Column A B C D...
Tires 175/70/13 185/70/14 225/95/21

is something like that you have?

regards from Brazil
Marcelo



"Joao Saraiva" escreveu:
 
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
................
..................
.................
 
ok, and you are looking for something like this?

COLUMN A COLUMN B COLUMN C COLUMN D
Product Manufacturer Price prod
time
ABC B&Co 100 10


Regards from Brazil
Marcelo


"Joao Saraiva" escreveu:
 
Exactly ! Is it possible to do ?

Marcelo said:
ok, and you are looking for something like this?

COLUMN A COLUMN B COLUMN C COLUMN D
Product Manufacturer Price prod
time
ABC B&Co 100 10


Regards from Brazil
Marcelo


"Joao Saraiva" escreveu:
Click to expand...
 
yes,

Just select the range (80rows and 70 Cols)

COPY
PASTE SPECIAL (I suggest to do it in another sheet to preserv the original
data)

on the PASTE SPECIAL BOX, chek TRANSPOSE

regards
Marcelo



"Joao Saraiva" escreveu:
 
You have more responses to your other posts.

Joao said:
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
Click to expand...
 
Thanks ... it worked perfectly !

Marcelo said:
yes,

Just select the range (80rows and 70 Cols)

COPY
PASTE SPECIAL (I suggest to do it in another sheet to preserv the original
data)

on the PASTE SPECIAL BOX, chek TRANSPOSE

regards
Marcelo



"Joao Saraiva" escreveu:
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify excel database 4
Conditional Highlight 16
use month in cell date to sum all relevant cells 2
I would appreciate some help with a formula 3
Help With MS Access 4
divide column b by column a 4
extact certain information from sheet 1 to shhet 2 columns e:e and 2
Formula for 5

Back
Top