How to use "Add as New Query" in Power Query Editor on multiple tables generated by "Group By" function at once?

Question

I'm using the "Group By" function in Power Query Editor and generating a table with 3 columns "Row", "Column" and "Well" like this:

Currently I have to right-click on every table and select "Add as New Query", which is very time consuming in big tables. Is there a way to automate this, so it's opening all the new queries automatically with the name of Row_Column as displayed here, e.g. in the advanced editor?

Answer 1

Good afternoon!

OK?

Is the source files Excel for all tables?

Do the tables have the same column structure?

Does the spreadsheet with the data have the same name in all the files?

Finally, if the answers to the above questions are yes, then you have already tried to get the data from the Get connector from the folder?