Please find attached the excel file containing a pivot table (PivotTable1). From this table i need the list of projects in an excel macro.
The expected output is -
I was trying to acheive this using the getPivotData function, but no luck. Can someone please help me?