Q? About sort data in merge excel data

I’ve merge multiple excel files but found that the merged data is not sort by file name.
How to sort Excel Merge data by file name. :wink:

Hi @Phunya

Before merge the data you can loop though your files using for each file in folder, and order it as the following

Then merge one by one

Regards

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.