Add as new query from existing query

[GoatTracker]

Hi brains trust,

I've Grouped by the ID field and want to dynamically create a new query from the Table it generates per Project. At present, I have to right-click each row's Table and select "Add as new query". This would be painful. ANyone got some adeas to resolve please?

I'm trying to create individual worksheets from a master list by Project, I haven't been able to do this without VBA but if someone has a solution, I'd be happy to see it.

[BA_Pete · Accepted solution]

Hi @GoatTracker ,

If you really want to follow this course then I think VBA is your best/only bet.

Power Query can't spawn new queries itself and anything we could do to make this happen would be very fiddly, and neither particularly dynamic nor robust.

Have you considered having just one generic Project tab that you change the data in using a pivot slicer against your main project table?

Pete