tim kirkland
New Member
Members
Forum Posts: 2
Member Since:
August 16, 2020
August 16, 2020
Offline
I am trying to manipulate an indented bill of material report to identify what the top level assembly is for each component. I am able to do it in VBA but need it to be done within Power Query... any help would be appreciated. The Macro is really simple and is included.
In the attachment, I start with A, B and C. Level is the BOM indention level and I am trying to assign the cell (E) "Top Level" with the Component Part Number that is on level 1 above it. I added the output I need in E.
The real file is about 7000 lines long with indentions up to 10 deep.
Thanks
Tim K
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Riny van Eekelen, Riaan van Zyl, Dirk Veeken
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 287
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Nicole White
Adrian Macleod
Ed Norris
manoj Ka
Chris Cowan
Pawel Ganczarski
Molly King
Faraz Rafi
Anthony Blake
Jackb57
Forum Stats:
Groups: 3
Forums: 24
Topics: 6873
Posts: 30127
Member Stats:
Guest Posters: 49
Members: 33677
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —