Forum Discussion
Solved
Power Query: Transpose part of a table
Suppose I have a table like this: +------------+---------+------------+-------------------------------------------------------+
| Category | Class | Function | Capability ...
Hi Mr_Gou
Interesting scenario. I doubt there's a way to do it with the UI/Menus only...
In attached file all steps are done with the UI but Grouped Rows that's been altered with the Advanced Editor to add an [INDEX] column to each nested table
Re. the Pivoted Column step the "trick" is - when doing it with the UI: