How to combine data from multiple rows into a single row / multiple columns

Good morning,

I wonder if once again someone could offer me advice.

I need to create a mail merge from excel data, the issue is the information required for individual customers is held in multiple rows rather than a single row.

I have created a separate worksheet with all customers details in columns and I am looking for help to move particular details from each row relating to that customer into a defined column.