I have a spreadsheet where i have an customer number in the first column, and
the item number each customer has ordered in the subsequent columns.
In order to import this into a table in Access, I would like to change this
into two columns, where the first column is the customer number, and the
second column is the item number.
The customer number will then be repeated in column A one time for each item
the customer has ordered. A customer ordering 2 items will occupy two rows,
and a customer ordering 10 items will occupy 10 rows. For the Access database
import this will fit with one record in each row.