Combining data from multiple Excel files on a Mac can feel impossible. Power Query in Excel for Windows has Get Data from Folder. Power Query in Excel for Mac doesn’t.
In this video I’ll show you how simple it is to combine data from multiple Excel files stored in a single folder using Power Query in Excel for Mac.
Once it’s set up, you can bring everything together into one clean table and refresh it in seconds.
Download a copy of the file(s) used in this video: https://share.zight.com/jkuG7kPj