automatically create a new query for each row of a Group By operation

[halifaxious]

I have a dataset with 2 columns: Site, Facility. Each Site has many Facilities. So I grouped by Site to get a table of each set of Facilities. Each table of Facilities has 2 columns: Site, Facility.

I'd like to do the following:

1. have my Group By operation result in a Facility column that contains a one column table instead of a 2 column table. I don't need the Site column in my sub table.
2. automatically load each of the sub tables into the Excel using the name of the Site for the table name. I could do this manually by using the 'create new query' option. But I have a lot of Sites and that would be a pain. Plus, I might unexpectedly get new Sites.

[Anonymous]

Hi there @halifaxious pls let me know if u got a solution,I am desperately looking for the solution to this problem load to different sheets 

[ImkeF · Accepted solution]

Hi @halifaxious ,
depending the data sources, VBA or JavaScript is your friend here.
No way to do this natively in PowerQuery.