There are multiple card-style files as follows:

Andrew.Fuller.xlsx：

Janet.Leverling.xlsx：

Margaret.Peacock.xlsx：

Nancy.Davolio.xlsx：

…

Now we want to merge them to form one row-based table. The merged format is as follows:

Employee.xlsx：

Script:

A1: List all files named by Name in the Cards directory

A2: Create a result table sequence

A3: List the cell names in the card-style files to be read

A4: Loop through the files in A1

B4: Open the files

B5: Read the data of the cells listed in A3 in the file

B6: Insert the data in B5 into A2

A7: Write the table sequence in A2 to Employee.xlsx

esProc Desktop and Excel Processing
4.18 Merge by row and column simultaneously - keep data that firstly appear
4.20 Format conversion - merge multiple primary-sub table files to form two row-based tables