Combining Multiple Rows into one based on specific column.

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

See if the attached works.

Thanks for the help!

once I used this on my PC install (Mac wouldn't work because of the ActiveX) it worked great with the file I gave you. Of course, my real file has more columns and it gives me a Run Time error 1004. Object defined error. I am sure it has to do with that difference. I couldn't seem to put together how to fix that though.

My real file has 35 columns, and columns 19-25 are the ones that need to be transposed.

Thanks again!