Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
1,326
Views
Topic starter
Hi,
I have PQ that cleans and transforms the data, but to automate the process, I need the nested tables to be loaded into different tabs of the current workbook. Since I'm relatively new to PQ, I'm unsure if it is feasible. The screenshot of the current step is attached. Any suggestions or inputs are very appreciated.
P.S. The data in the Column "Consultants" is dynamic.
Posted : 26/07/2023 8:59 am
Hi Farah,
PQ cannot split the result of a query into multiple sheets.
You can try loading all data in a single table, then create a pivot table, that can be split into report pages:
https://www.myonlinetraininghub.com/show-report-filter-pages-for-power-pivot-pivottables
Posted : 30/07/2023 6:52 am