How can I get a list of all the "data" items in the rows of a pivot table?

[TheRedCardinal]

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!