Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to change an Excel file to be database friendly
I have a file that is stored in a column type fashion, when I transpose the
the worksheet so it will be more database friendly, rows, I end up with multiple serial numbers in columns to the right rather than down. Example This is what I have now: Part Nbr Part Desc Inventory Location Date of Inventory Serial Nbr 12345 XYZ New York 03/12/08 543 709 2889 2803 555 4321 ZZZ New York 03/12/08 123 321 456 654 This is what I want: Part Nbr Part Desc Inventory Location Date of Inventory Serial Nbr 12345 XYZ New York 03/12/08 543 12345 XYZ New York 03/12/08 709 12345 XYZ New York 03/12/08 2889 12345 XYZ New York 03/12/08 2803 12345 XYZ New York 03/12/08 555 12345 XYZ New York 03/12/08 2884 4321 ZZZ New York 03/12/08 123 4321 ZZZ New York 03/12/08 321 4321 ZZZ New York 03/12/08 456 4321 ZZZ New York 03/12/08 654 4321 ZZZ New York 03/12/08 789 4321 ZZZ New York 03/12/08 987 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200805/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trying to change an Excel file to be database friendly
Please Ignore this Thread sent in error
Carrie_Loos wrote: I have a file that is stored in a column type fashion, when I transpose the the worksheet so it will be more database friendly, rows, I end up with multiple serial numbers in columns to the right rather than down. Example This is what I have now: Part Nbr Part Desc Inventory Location Date of Inventory Serial Nbr 12345 XYZ New York 03/12/08 543 709 2889 2803 555 4321 ZZZ New York 03/12/08 123 321 456 654 This is what I want: Part Nbr Part Desc Inventory Location Date of Inventory Serial Nbr 12345 XYZ New York 03/12/08 543 12345 XYZ New York 03/12/08 709 12345 XYZ New York 03/12/08 2889 12345 XYZ New York 03/12/08 2803 12345 XYZ New York 03/12/08 555 12345 XYZ New York 03/12/08 2884 4321 ZZZ New York 03/12/08 123 4321 ZZZ New York 03/12/08 321 4321 ZZZ New York 03/12/08 456 4321 ZZZ New York 03/12/08 654 4321 ZZZ New York 03/12/08 789 4321 ZZZ New York 03/12/08 987 -- Message posted via http://www.officekb.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create an "import-friendly" text-file from excel? | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
Change database in Excel | Excel Discussion (Misc queries) | |||
Change database in Excel | Excel Discussion (Misc queries) | |||
How do I set up a user friendly inventory system using Excel as b. | Excel Programming |