Power Query (Maybe)

Hi, I am working with several thousand Bill of Materials and the current spreadsheet is 150K+ lines. Office 365
There are multiple assemblies with various parts and number of parts.

Here is the mission:
Find the obsolete items and replace with active parts. (this should have been an ongoing process, but, what ya gonna do)
Here is the rub: NetSuite needs a full revision uploaded via CSV. Can't just use a CSV to replace one item. You must upload a new revision and then populate with all needed items. So we need to find the obsolete and all other active items in the BOMs and then create a CSV with all active items to upload to NetSuite.

I will try to explain a different way.

1. Download raw data from NetSuite (NS)
2. Find obsolete items to be replaced. Could be multiple items.
3. Find the BOM name with the obsolete items. Could be multiple obsolete items in one BOM.
4. Copy and paste the entire BOM with active and obsolete items into another sheet.
5. Find and replace all obsolete items.
6. Create and load CSV.

I hope this isn't confusing. Going to try to upload a few samples to help.

Thank you in advance

Tim