Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
41
Views
Topic starter
Thanks for suggesting this platform. So my question is how to split the data based on the "SheetName" mention in the attached file consisting different fields in each sheet (consolidated monthly reports in this master sheet for cleaning and transforming purpose). It would be great if you can guide me through the process.
Posted : 17/06/2021 11:56 am
Hi Jignesh,
Welcome to our forum!
If I understand correctly, you want the data split into separate sheets based on the SheetName field. In which case, this isn't a job for Power Query. You can do this with PivotTables as explained here.
Mynda
Posted : 17/06/2021 7:45 pm
