Forum Discussion
Pulling non-number data from a pivot table
I am fairly new to pivot tables and am stuck on the getpivotdata function. I have a pivot table set up like the attached example, with vendor names, contract titles, contract numbers, expiration dat...
I offer you a Power Query solution. The pivot table is not needed anymore.
Since your source data comes from an external database the Source step in PQ will be different.
Load the source data and the additional data into the PQ editor as a connection only. The source data has to be grouped in the same way as the pivot table.
Merge both tables as a new query and expand the two additional columns and load it into the worksheet-
The additional table and the merged table get a helper column to check whether all rows are in the other table respectively.
I got as far as opening the data in power query, only to find I don't have permissions to use the connection string. The database and pivot table are managed by another department. Perhaps they'll give me permission, if not, I'm going to write this one off as a case of "do it by hand". Thanks for your help, DetLef!