Forum Discussion
Solved
Pivoting Nested Columns
Hello! So I need to create a dashboard based on multiple excel files that involve multiple nested columns which look like this (mock data for privacy purposes). Obviously, this data i...
Please see this article/video for how to do this.
Transform ANY nested table to Pivot Table with function query - DataChant
Pat
Please see this article/video for how to do this.
Transform ANY nested table to Pivot Table with function query - DataChant
Pat
Hi Pat!
Thanks for this. I wasn't allowed to edit the excel file itself but the whole solution still works as long as the data is already on Power Query.
Thank you so much!
R
