| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modify database
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Modify database
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: 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Modify database
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 ................ .................. ................. "Marcelo" wrote in message ... 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: 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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Modify database
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: 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 ................ .................. ................. "Marcelo" wrote in message ... 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: 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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Modify database
Exactly ! Is it possible to do ?
"Marcelo" wrote in message ... 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: 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 ................ .................. ................. "Marcelo" wrote in message ... 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: 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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Modify database
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: Exactly ! Is it possible to do ? "Marcelo" wrote in message ... 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: 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 ................ .................. ................. "Marcelo" wrote in message ... 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: 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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Modify database
You have more responses to your other posts.
Joao Saraiva wrote: 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 -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Modify database
Thanks ... it worked perfectly !
"Marcelo" wrote in message ... 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: Exactly ! Is it possible to do ? "Marcelo" wrote in message ... 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: 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 ................ .................. ................. "Marcelo" wrote in message ... 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: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Total Sales from a Database | Excel Worksheet Functions | |||
| Database Query | Excel Discussion (Misc queries) | |||
| Database functions should use criteria in formula, as 1-2-3 does | Excel Worksheet Functions | |||
| Links to External Database | Excel Discussion (Misc queries) | |||
| Graphing Database Growth Rate | Charts and Charting in Excel | |||
Linear Mode
