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: 4515
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:
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
SunnyKow: 1432
Anders Sehlstedt: 873
Purfleet: 414
Frans Visser: 346
David_Ng: 306
lea cohen: 222
Jessica Stewart: 215
A.Maurizio: 202
Aye Mu: 201
jaryszek: 183
Newest Members:
Anthony van Riessen
Erlinda Eloriaga
Abisola Ogundele
MARTYN STERRY
Rahim Lakhani
Ngoc Qui Nguyen
Clement Mansfield
Rose .
Bindu Menon
Baruch Zemer
Forum Stats:
Groups: 3
Forums: 24
Topics: 6352
Posts: 27779
Member Stats:
Guest Posters: 49
Members: 32319
Moderators: 3
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: MOTH Support, Velouria, Riny van Eekelen
© Simple:Press —