TheRedCardinal
Board Regular
- Joined
- Jul 11, 2019
- Messages
- 243
- Office Version
- 365
- 2021
- Platform
- Windows
Firstly sorry for the confusing terminology here!
I am looking for a way to extract the contents of each row of a pivot table, but only from the the "rows" columns - i.e. I'm not interested in the data itself at this stage.
I would normally do this by constructing a dictionary item from the source data and outputting it to the range I want it in. But this feels unnecessary if it's already available in a Pivot Table?
I could also do it by using row counts to find the limits of the pivot table, and find to locate the right columns - but again unnecessary?
Thanks for any tips!
I am looking for a way to extract the contents of each row of a pivot table, but only from the the "rows" columns - i.e. I'm not interested in the data itself at this stage.
I would normally do this by constructing a dictionary item from the source data and outputting it to the range I want it in. But this feels unnecessary if it's already available in a Pivot Table?
I could also do it by using row counts to find the limits of the pivot table, and find to locate the right columns - but again unnecessary?
Thanks for any tips!