Table with headings in rows?

[Anonymous]

Hello everyone

I have to create a report about workers, but this report should be builded like a photo. I have a table with about 9,000 rows (amount of rows is floating) and one heading with name of columns.

How can I do it by PowerQuery? Data is downloaded from our SAP, so I need to do it by PowerQuery.

[wdx223_Daniel · Accepted solution]

Table.Combine(List.Transform(Table.Split(PreivousStepName,1),Table.DemoteHeaders))

[Anonymous]

Awww It's fast and simply! Thank you so much.

[Anonymous]

Pretty slick.