Moving data from multiple rows into single row/multiple columns

Good afternoon,

I have a list of orders for clients in a single workbook, each order for a customer is on a different row, on a new work sheet I would like to move the individual orders to a single row to allow me to use this data to create a mailmerge invoice/statement for each customer.

I have mocked up an example of what I am trying to achieve - if someone could suggest a formula to allow this to be automated it would be appreciated as I have over 800 customers with a variety of items to be moved.

Thank you in advance

Thank you so much for taking the time to look and reply, this is just what I needed.