Forum Discussion
Solved
Pivot table in power query,
hello, there is a help to make the Pivot table in the picture in a power query. Picture of the table below. It will make the job much easier and simpler in a situation like the first pictur...
Afraid not. Power Query works with tables which, returned to the grid, are structured table. Such table has fixed number of columns which are not collapsed/expanded (and partly filtered) as in PivotTable.
You may play with Power Query to return structured table in more suitable way, but in any case that won't be repeating of PivotTable with few fields in Columns.
Afraid not. Power Query works with tables which, returned to the grid, are structured table. Such table has fixed number of columns which are not collapsed/expanded (and partly filtered) as in PivotTable.
You may play with Power Query to return structured table in more suitable way, but in any case that won't be repeating of PivotTable with few fields in Columns.
SergeiBaklan
Thank for your answer
Thank for your answer