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?
Bookmarks