iosiflupis
New Member
- Joined
- Jan 26, 2022
- Messages
- 39
- Office Version
- 365
- Platform
- Windows
I have five (5) different files that have .csv files in them. The five folders of information have five different columnar layouts. Is there a tool/trick/workaround in Power Query or Power BI where I can pull the different columns into one worksheet/table that has all the columns that I would like to have? Most of the columns in three of the folders/files are the same just not in the same location. The other two folders/files layout and column headings are completely different. I have attached a screenshot, but it is not all of the columns, there would be ~54 of them.