Forum Discussion
rachel
Nov 03, 2023Iron Contributor
Merge multiple excel files into different tabs of one workbook using Power Query on Mac
Hello, I have 33 excel files in one folder. all of them have data in "Sheet1". the data are in the same position in each file. I am trying combine those data from different files into one wor...
- Apr 15, 2024
Here is the variant, but made on Windows
peiyezhu
Nov 05, 2023Bronze Contributor
https://answers.microsoft.com/en-us/msoffice/forum/all/thank-you-guys-for-everything/92b0958c-3e57-4b92-b072-233ed915f268
By the way,you can run any sql as above.
On PC side,drag and drop files on file picker also available for upload .xlsx files.
By the way,you can run any sql as above.
On PC side,drag and drop files on file picker also available for upload .xlsx files.
peiyezhu
Nov 07, 2023Bronze Contributor