|
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 |
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 |
| All times are GMT +1. The time now is 10:16 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com