Power Query Magic: Consolidate 300+ Excel Files with Different Sheet Names

Hello and a very good day everyone,

In this video, I share how I use #PowerQuery to consolidate more than 300 files into 1 #MicrosoftExcel report.

Each Excel files has different sheet name.

Following are the steps :
1. I placed all the files into one folder
2. Then I use Power Query to extract the file from the particular folder
3. I clicked transform data and it will be navigated to Power Query Editor.
4. I use Custom Column and use the function Excel.Workbook() to extract the sheets from each files.
5. Later, I expand the files and perform data cleaning
6. Eventually, I load these files in Pivot Table so that I can perform data analysis

Kindly refer to the video. Should you have any #questions, feel free to #ask in the #comments section

Thank you.

Видео Power Query Magic: Consolidate 300+ Excel Files with Different Sheet Names канала Learn with Elen 📖📚