There is a product data table ProductCategories.xls:

This table contains the category information of products, such as CategoryID, CategoryName, Description, etc. Now we need to separate the category information columns to form one Categories table, and take the remaining product columns as the Products table. Since there are many products under one category field, and many of them are duplicate after splitting, deduplication needs to be performed.

The results after splitting are shown as below:

Categories.xlsx：

Products.xlsx：

Script:

esProc Desktop and Excel Processing
5.9 Split by column - by column - take column name as Sheet name
5.11 Split multi-Sheet file into multiple files - unfixed number of Sheets