Forum Discussion
Combine multiple Excel files
I want to combine multiple Excel files from one folder with below header.
What is the best way to combine in Power BI
Thanks,
| Store # | Address | City | St | Service Date | Billing | Service Date | Billing | Service Date | Billing | Service Date | Billing | Service Date | Billing |
| 19 | ABC | AAA | MI | 5/4/2021 | $18.50 | 5/11/2021 | $18.50 | 5/18/2021 | $18.50 | 5/25/2021 | $18.50 | 6/1/2021 | $18.50 |
This video will help you explaining the same
Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)
3 Replies
This video will help you explaining the same
Easiest way to COMBINE Multiple Excel Files into ONE (Append data from Folder)
Thank you for this link, I've spent two days searching for that instruction!
