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?
<tbody>
</tbody>
Regards!
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!