Forum Discussion
amirghaderi
Helper IV
Helper IVCombine multiple Excel with multiple tabs (Different number of tabs/names)
I am trying to combine multiple Excel files in Power Query with all tabs in one table. A few conditions which making it a bit difficult for me. I have put a copy of two sample files in the below link...
You can download the solution from here (Change the path from C:\Test to your path)
Vijay_A_Verma
Most Valuable Professional
Most Valuable ProfessionalYou can download the solution from here (Change the path from C:\Test to your path)