How to automatically sort data using VBA/Programming

Hi,

I'm looking to sort the data shown in the attached workbook to a new format. The issue is that the raw data displays every serial number associated with each MSN under each other, I would like these to be beside each other instead to track each MSN more efficiently. I've been able to sort the serial numbers so they are listed beside each MSN using VBA but I haven't been able to make sure each serial number brings its associated columns of data with it

Any help with this would be greatly appreciated

Yes, currently the same MSN will be there in there twice (maybe even 4 times) with 1 Engine serial number beside it.

Thank you