Tool Databases

Split Master Excel into separate worksheets by end node:

https://www.extendoffice.com/documents/excel/785-excel-save-export-sheet-as-new-workbook.html

Step 1:  Delete End Node, Supplier. Supplier id, Web Item, UPC, Additional Information columns. Click Save.

00

Swap Brand and MSC number columns (make brand column A)

Step 2: Split into workbooks by brand name:

https://www.extendoffice.com/documents/excel/1174-excel-split-data-into-multiple-worksheets-based-on-column.html#:~:text=you%20need%20to%3A-,1).,2).