Forum Discussion
Table with headings in rows?
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.
Table.Combine(List.Transform(Table.Split(PreivousStepName,1),Table.DemoteHeaders))
3 Replies
Table.Combine(List.Transform(Table.Split(PreivousStepName,1),Table.DemoteHeaders))