Exce help needed - How do I convert to a database loadable csv file
Posted on 2013-01-18
I believe there must be an easier way to format the data in an excel spreadsheet
Can someone please help me out here???
Here is the problem.
The data looks as follows
StoreId,product, price StoreId,product, price
1 ,Castle Toy, 30.00 2 PinePen 12.50
1 SeaPlane, 45.00 2 GumDrop 5.77
1 HoolaHup6, 12.67 2 UniveralFan 26.99 ...
The data is broken out across the columns by storeID e.g 3,4,5,6... N
Right now I copy and paste each 2 columns in an effort to create a 2 field list for loading
How would I do this in a more efficient manner in Excel???
1 ,Castle Toy, 30.00
1 SeaPlane, 45.00
1 HoolaHup6, 12.67
2 PinePen 12.50
2 GumDrop 5.77
2 UniveralFan 26.99
I imagine for the skilled Excel person this is simple - Please advise!!