Multiple Rows into Multiple Columns

[christian_1971]

Hi

I have a table that contains multiple columns with multiple values and I need to format it into a "key value" from the first column with multiple columns made from the values in the second column.  The key column is an office name I then have multiple rows for client, main contractor and operator relating to this office name that I want to show as columns NOT rows i.e. I have one row per office name.

Please help 

[v-shex-msft]

Hi @christian_1971,

Please provide some sample data expect result to help use clarify your scenario.

It is hard to clarify your requirement and test to coding formula without any detail sample data. 

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng