There is a multi-card style table Cards.xlsx as follows:

Now we need to split it to make one card generate one file, with person’s name as the file name. The splitting results are as follows:
Andrew.Fuller.xlsx：

Janet.Leverling.xlsx：

Margaret.Peacock.xlsx：

Nancy.Davolio.xlsx：

…

Operation steps:

1 . Create an empty card-style file Card.xlsx, as the initial file format:

2 . Script:

A1: Open the empty card-style template Card.xlsx.
A2: Open the multi-card style table Cards.xlsx.
A3: List the column number of the cells to be read.
B3: List the row number of the cells to be read.
A4: Piece together the cell names of the first card.
A5: Loop.
B5: Piece together the cell names of the current card, and read the data in it.
B6: Exit loop if cards have been read.
B7: Loop through A4 and write the data in B5 into A1 one by one.
B8: Write A1 to the file named after the current card.
B9: Plus 8 after row number, because one card has 8 rows.
 

esProc Desktop and Excel Processing
5.5 Split by row - generate one card per row
5.7 Format conversion - split tables with primary-sub relationship into cards