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.