[Help] Formula to move numbers from one column to multiple rows

[colbyclay]

Hi all,
I have 1400 Serial number that have a series of codes associated with them. There are too many for a pivot table so I cut/pasted them to a new spreadsheet. I would like to move the codes from under the serial numbers in column A to the rows next to the Serial Number. Can anyone help?

CURRENT		DESIRED
15090044		15090044	693	701
693
701
15090045		15090045	191	315	567
191
315
567
15090136		15090136	812
812

<tbody>
</tbody>

Regards!

 

[colbyclay]

So you do not me to modify my code to handle 6-digit SN's or SN's that contain letters then, correct?

Rick,
I realized that if I could modify the SN with letters, I could add a 0 at the end of the short one too. Again, thank you for the time and patience with me...This worked perfectly.

 

[Rick Rothstein]

Rick,
I realized that if I could modify the SN with letters, I could add a 0 at the end of the short one too. Again, thank you for the time and patience with me...This worked perfectly.

Okay, great... I just wanted to make sure.