We have an order table file orders. xlsx, and part of the data is shown in the figure below. The first row contains the column titles, and the data start from the second row with one piece of data per row.

Now we want to group the data in this table by Shippers, and store each grouped data to one separate Sheet, with the Shippers name as the Sheet name. The split results are as follows:

Ordersm.xlsx:

Script:

A1: Read the data in orders.xlsx.

B1: Group by Shippers.

A2: Loop each Shippers group.

B2: Take the Shippers name as the Sheet name, and write the grouped data in A2 to the Sheet.

esProc Desktop and Excel Processing
5.1 Split by row - by number of rows
5.3 Split by row - group by data - split into multiple files