Forum Discussion
Combining spreadsheets
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 hav...
PQ can do a lot, but it is designed to get one "table" per set of files. So you're looking at creating four queries. Is it possible to use something else than the heading to determine which files to use for each heading type? File name or location for example? Alternatively, you could create a query that just fetched the headers from each file so it can determine which files belong in which group. Then you could design a query for each "heading type" and filter the list of files against the first queries' results.
Thanks for the response Jan, will try it out!