There is a file Amount.xlsx as shown below:

This is an amount summary table for certain products purchased by some key customers. Now we need to split it by product, and save each product as a file with the product name as the file name and Amount as the column name. The split results are as follows:
Apple.xlsx：

Bread.xlsx：

Pork.xlsx：

Script:

esProc Desktop and Excel Processing
5.7 Format conversion - split tables with primary-sub relationship into cards
5.9 Split by column - by column - take column name as Sheet name