June 28, 2016
Is there any way that when you load a PQ that you can have it out put to different worksheets (adding as needed) based upon the number of entries?
What I would like is for a list of location to be broken down into different worksheets when loaded back in (I currently use VBA to do this)
So I have 10 unique locations and when PQ is ran it would have 1 raw worksheet and 10 unique locations sheets added in (total of 11 worksheets)
Is this something that can be done via PQ?
November 8, 2013
Usually, it's about merging data with PQ, not splitting. Having the data spead across multiple sheets creates problems when trying to create reports.
You can try loading the query as connection only, then insert a pivot table based on that connection, with Location in filter area. You will then be able to use pivot option Show report Pages, this will split data into one sheet per location. Again, bad idea, because you can simply use a slicer to filter the report instead of splitting the data.
July 16, 2010
The PivotTable technique Catalin describes is explained in this tutorial: https://www.myonlinetraininghu.....tract-data