Log In
Register
Home
Expand table to include another table
Garb I
Active Member
Members
Forum Posts: 4
Member Since:
July 21, 2021
July 21, 2021
Offline1
August 2, 2022 - 6:41 pm
Hi
I have multi level BOM with 2 sheets in excel. I want to expand and try to see all the components within one table as per the sample. I'm wondering if the power query will be able to do that for me?
Riny van Eekelen
Örnsköldsvik, Sweden
Moderator
Members
Trusted Members
Moderators
Trusted Members
Moderators
Forum Posts: 614
Member Since:
January 31, 2022
January 31, 2022
Offline2
August 2, 2022 - 10:09 pm
With a 2-level BOM it's relatively easy. With your set-up it takes a merge, a few consecutive steps of combining columns and cleaning up. Quite easy to follow. If your real situation has more levels it becomes more complicated.
In the attached file I've added a PQ solution for you to consider.
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Ruth Savage, Lorna Henning
Guest(s) 7
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:
Appiagyei Kofi Frimpong
Hilary Burchfield
Richie Wright
Adel Kock
Barbara Murray
Doug Milne
Siobhan Stringer
Rob Rooth
Tom Lewis
Jennifer Rodriguez-Avila
Forum Stats:
Groups: 3
Forums: 24
Topics: 6542
Posts: 28641
Member Stats:
Guest Posters: 49
Members: 32829
Moderators: 2
Admins: 4
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea, FT
Moderators: Velouria, Riny van Eekelen
© Simple:Press —