How to Pivot Multiple Values to Row Column Header

[Anonymous]

I feel like I'm running at a blank, how can I convert this data set so that only the first 11 rows are column headers. I have rows of this information but only "Date" to "Prime Firm" are needed for column headers, the data to the right (not shown) should fall underneath like the example in the second screenshot. 

[v-luwang-msft]

Hi @Anonymous ,

See the below,for an example:

base table:

1. Transform data:

transpose table:

after transpose table:

2.Then use the first  row as header:

3.After apply and then delete other column you do not need.

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien

[HotChilli]

I suppose it depends on what the rest of the data looks like.

Have you tried 'Keep top rows' from the PQ interface?