Combining multiple rows of data into one row

[bedrockjase]

Hi there,

I have a spreadsheet that has booking reference numbers on and multiple rows for different suppliers within that booking reference. Is it possible to combine the data on multiple rows into one row - see screen shot

What I would like to do with this example is have one row for reference number 123456, with all of the data from the 3 rows together. i.e. i'd like the property name, supplier 1, supplier 2, supplier 3 to be all in one row under their specific columns rather than over 3. I know I could copy and transpose, however the spreadsheet i'm using has thousands of rows, so hoping there is a formula that will do this for me?

Many thanks

 

[Automatrix]

How would the result look?

 

[bedrockjase]

This is what I would like the end result to be - so the 3 rows of data combined into one -thanks

 

[Automatrix]

Can you have more than 3 suppliers?

 

[bedrockjase]

Can you have more than 3 suppliers?

Potentially there could be more than 3 rows for each booking, but I would think the most would be 5 if that helps

 

[Automatrix]

I think the Pivot Column function in Power Query can help you with this, but I haven't used it much myself. From a database standpoint, many rows + few columns is preferable. Here's a place to start:

Pivot columns (Power Query)