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

[TABLE="width: 500"]
<tbody>[TR]
[TD]CURRENT[/TD]
[TD][/TD]
[TD]DESIRED[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15090044[/TD]
[TD][/TD]
[TD]15090044[/TD]
[TD]693[/TD]
[TD]701[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]693[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]701[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15090045[/TD]
[TD][/TD]
[TD]15090045[/TD]
[TD]191[/TD]
[TD]315[/TD]
[TD]567[/TD]
[/TR]
[TR]
[TD]191[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]315[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]567[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15090136[/TD]
[TD][/TD]
[TD]15090136[/TD]
[TD]812[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]812[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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.