How to extract data from a pivot table???

[DigitalZugzwang]

Hi All,

I posted a question earlier but one tip led me to my newest sticking point. How can I use a {=index(list,match(0,countif(uniques,list),0))} type array when I want to pull the data from a pivot table? Below is the pivot table I'm working with.

Job No	1001
Cost Category	(All)
Site	Activity	Component
OMG	Site Support	Labor: Support
	Upgrade/Repair	Dish
Test	Decommission	Antenna
		Lines
		Tower
	Erection	Flag Pole
		Guyed
		Monopole
		Water Tank
	Install	Antenna
	Site Support	Labor: Support
	Tower Modification	Ice Bridge

<colgroup><col width="94" style="width:70pt"> <col width="143" style="width:107pt"> <col width="96" style="width:72pt"> </colgroup><tbody>
</tbody>

I need to apply that array to this pivot table. Then at some point I need to CONCATENATE the activity and component data into one cell for each site. If you have suggestions for that second step as well, I'm all ears.

Thank you so much. I've put so much time into this project only to get absolutely stuck on the payoff.

 

[DigitalZugzwang]

Bump...wow, posted at 11 pm and 7 hours later this is 5 pages deep.