Using Power Query to combine multiple Excel files from same folder
We can combine multiple Excel files from a folder into one Workbook and create a table or a a pivot table report based on the consolidated data.
Credit to Leila Gharani
Please support our Sponsors here :
