I would like to combine records into a single cell by 'Order' and 'Row' as shown in my example. There are thousands of records in the spreadsheet. I can do this manually, but it is extremely tedious. The number of rows for any given 'Order' vary. I can't find a way to do this with 'standard' Excel, but I think there must be a way with VBA. If someone could help me by providing the code (the more detailed and specific, the better), I would really appreciate it.

Thank you!

excel row combine.jpg