Combine (Merge) multiple excel files (.xlsx) into 1 file (Same columns stack 1 another)

[timework0]

Hello all experts : )

I would like to Combine (Merge) multiple excel files (.xlsx) into 1 file (Same columns stack 1 another)

Below are some screenshots from the files I would like to merge, there are 130 files.

Let's start with smaller sample, I would like to combine file 117 and 22 (containing 3 items and 4 items respectively)

It is easy to copy and paste them into another excel file (Combination of 117 and 22)

Come back to the real thing, are there any suggestion for me to combine all 130 files into single file with same method as copy + paste like 2 sample above ?

Thank you everyone in advance

 

[sandy666]

maybe try Power Query with From Folder feature

Import data from a folder with multiple files (Power Query) - Microsoft Support

Use Excel's Get & Transform (Power Query) experience to combine multiple files, which have the same schema, from a single folder into a single table.

support.office.com

 

[timework0]

maybe try Power Query with From Folder feature

Import data from a folder with multiple files (Power Query) - Microsoft Support

Use Excel's Get & Transform (Power Query) experience to combine multiple files, which have the same schema, from a single folder into a single table.

support.office.com

Thank you a lot, now I am trying it.

 

[timework0]

maybe try Power Query with From Folder feature

Import data from a folder with multiple files (Power Query) - Microsoft Support

Use Excel's Get & Transform (Power Query) experience to combine multiple files, which have the same schema, from a single folder into a single table.

support.office.com

I got this error : (

 

[sandy666]

so check files in folder