Log In
Register
Home
Split into sheets using power query
Jignesh More
New Member
Members
Forum Posts: 1
Member Since:
June 17, 2021
June 17, 2021
Offline1
June 17, 2021 - 1:56 am
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.
Mynda Treacy
Admin
Forum Posts: 4619
Member Since:
July 16, 2010
July 16, 2010
Offline2
June 17, 2021 - 9:45 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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Philip Treacy, QSolutions Group
Guest(s) 8
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 880
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 237
Jessica Stewart: 219
A.Maurizio: 213
Aye Mu: 201
Hans Hallebeek: 185
Newest Members:
Kate Dyka
Kwaje Alfred Mogga
thong nguyen
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Forum Stats:
Groups: 3
Forums: 24
Topics: 6547
Posts: 28656
Member Stats:
Guest Posters: 49
Members: 32832
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —