Aug 14 2022 04:50 AM
Currently, I have around 60 different spreadsheets with data. But not all the spreadsheets have the same header. I want to combine all these 60 tables of data based on the headers. So lets say 15 have the same header then they get combined as one (and similarly for the remaining spreadsheets). Ultimately for example if the 60 spreadsheets have 4 different headers in total, I want to be able to get 4 different tables.
I am able to code in VBA so that shouldnt be any problem but from what I understand, Power query is able to combine data like this. So what should I do and how? Would appreciate any help with this matter!
Aug 15 2022 07:39 AM