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
Moderators
Moderators
Forum Posts: 1047
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:
Guest(s) 7
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1939
SunnyKow: 1432
Anders Sehlstedt: 925
Purfleet: 415
Frans Visser: 349
Hans Hallebeek: 343
David_Ng: 312
lea cohen: 248
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
WdwwPuKkx YjFmsfPYXpBW
Lisa Donaldson
roiAIAGUodrbOHw aCBaBxTfphIXDhr
Hiroyuki Murai
Mark Allen
Yves Gagnon
PATRICK WALTER
Carley Brice
Ash Rahman
Christelle Lamprecht
Forum Stats:
Groups: 3
Forums: 25
Topics: 7088
Posts: 31065
Member Stats:
Guest Posters: 49
Members: 34506
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —