Forum Discussion
amirghaderi
3 years agoHelper IV
Combine 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
https://www.dropbox.com/scl/fo/25v7fefmul009c412g2kn/h?rlkey=9kwri77yy9diryjsf2fonfs4k&dl=0
- The files have different number of tabs
- The files tabs names are different.
- The number of columns on the files are different. However, they are all consistent in term of heading up to column T . So, I want to remove all other columns after column T and just combine them up to consistent columns .
You can download the solution from here (Change the path from C:\Test to your path)
1 Reply
- Vijay_A_VermaMost Valuable Professional
You can download the solution from here (Change the path from C:\Test to your path)