I have found some answers close, but nothing that seems to adress my issue specifically. I have a sheet of Orders that are experiencing duplicate rows for each order and I need to eliminate that and combine those rows into one single long row for a lookup I need to use. You will notice that there is a lot of difference in the amount of rows for each order. Some orders have multiple items and comments, while some have only a single item.

Attached is a file that shows my original data and what I want to have in the end.

Thanks for the help!

combine.xlsx