I am needing to convert data from several workbooks so that I can import it
into Access. The worksheets are laid out similar to the following:

CustomerNumber # of Rows to add AccountNumbers
Original sheet

36798 3 158008 301976 897736 897728
37253 0 773751
37320 0 777838
37960 0 3770
38066 0 100216254
38562 1 91383 320978


Completed sheet

36798 3 158008
36798 301976
36798 897736
36798 897728
37253 0 773751
37320 0 777838
37960 0 3770
38066 0 100216254
38562 1 91383
38562 320978

I can do all of this manually using the Insert rows, copy and paste special,
transpose, etc. commands but I will wear out my keyboard and fingers doing as
many records as I have and am going to have.

What I would like is a macro that will read the number of rows that need to
be inserted, copy the applicable account numbers, paste them using the paste
special, transpose, and then copy the customer number down the same number of
rows.

Deleting the "old" account numbers would be nice but I can easily do that by
deleting the columns later.

Some of the customers have 30, 40, 50, or more account numbers and I have
calculated the number of rows to enter in the second column.

Your help is appreciated as I am not very good at programming and learn (and
copy) a lot from searching this and other discussion groups.