Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arranging data
I have an Excel spreadsheet that is imported from a Online orderingsystem,
thus the format is predefined. I need to arrange the data properly in order to import theese data to Access. I use Office 2003. Each line starts with a customerID number in column A. I the first row is listed the different items that has been ordered. One item in each coumn. If the customer in line 4 has ordered the item listed in column C, the cell C4 will have the itemID of that item. The result is a spreadsheet where each customer has severeal items ordered, but each for each item that is not ordered, the corresponding cell is left blank. I need to arrange the data so that each line starts with the customerID (as now), and all the items is listed from column B onwards removing all the blanks, and disregarding the item names listed in row 1. Row 1 will be deleted before the import. Suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need an Idea on Arranging Data for a Chart | Charts and Charting in Excel | |||
re-arranging the data | Excel Discussion (Misc queries) | |||
Help Arranging Data on Spreadsheet | Excel Discussion (Misc queries) | |||
Arranging Excel Data | Excel Discussion (Misc queries) | |||
Re-Arranging a Block of Data | Excel Programming |