Hi,

I have a workbook with multiple rows of data which contain multiple account numbers in each column.

Example; Sheet 1

Acct. #
A1 - 32456, 34763, 27365
A2 - 77456, 77893, 67345
etc. down.

I would like to create a Macro to CONCATENATE data in to Sheet 2 in the folowing;

Acct. #
A1 - 32456
A2 - 34763
A3 - 27365
A4 - 77456
A5 - 77893
A6 - 67345

etc. down.

Is this possible?