Split and Clean B2B Data

I’m holding one master Excel workbook that mixes three kinds of B2B records:

• Category A – every key field is present
• Category B – email is missing, website exists
• Category C – neither email nor website

Your job is to sort the rows into their proper groups, apply a bad-word filter, and hand back four clean workbooks.

I will send you a custom list of words and phrases that must be removed or redacted from every column before the export. Please keep the filename convention exactly as follows and do not add extra columns:

Deliverables
- Category_A.xlsx
- Category_B.xlsx
- Category_C.xlsx
- Combined.xlsx (the full, cleaned set)

No “Category” column is needed in any of the files. Feel free to use Excel, Power Query, Python (pandas), or any other reliable method—as long as the output opens flawlessly in Excel. Once done, return the four files and a brief note on the steps you used so I can reproduce the process later if needed.