Unmerge the cells in the columns A-K. Simply copy the first row of data for each serial# down until you get to the next serial number. Repeat for each. If this is all the data you need to work with, it's just a matter of some elbow grease.

Is this supplied by Microsoft?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post