Forum Discussion
A Question about Power Query
I am looking for a Power Query Function that allows me to query a folder which has several excel files in it and return values located in specific Tables. In each excel File I have 2 Tables calle...
Hi raphael94 ,
Power Query takes only one object from each file, that could be sheet or table. If you'd like to combine Table1 from first file with Table1 from second one, you need two queries. For Table1 - click on Transform data (or Edit, depends on version) instead of Load, filter your files if you have other ones in folder, remove all columns but Content, combine it and select Table1 on first step of the wizard.
Repeat the same for Table2 with new query.