Help with Concatence and Pivot Tables

[mdiangelo]

Good Afternoon Excel Guru's,

I have moderate excel skills (more like pretty good at Google searching) and I am new to concatenate and I believe this is the best function to use.
Monthly I will be pulling reports from a website and exporting to CSV from there it gets (VBA) imported to my program, It then becomes a pivot table arranged by names (Rows) and locations (Columns) with the count of the approver in the "Values field" the count will never be greater than 1. I am using Excel 2007 by the way.</SPAN>
Example:</SPAN>

A</SPAN>	B</SPAN>	C</SPAN>	D</SPAN>	E</SPAN>	F</SPAN>	G</SPAN>	H</SPAN>
1 Count of Approver</SPAN>	Column Labels </SPAN>	400</SPAN>	401</SPAN>	402</SPAN>	403</SPAN>	404</SPAN>	405</SPAN>
2 Row Labels</SPAN>
3 John</SPAN>		1</SPAN>			1</SPAN>
4 Joe</SPAN>			1</SPAN>		1</SPAN>		1</SPAN>

<TBODY>
</TBODY>

From this small sample I would like a cell to display:</SPAN>

1</SPAN>	John</SPAN>	400,403</SPAN>
2</SPAN>	Joe</SPAN>	401,403,405 </SPAN>

<TBODY>
[TD="align: center"]A[/TD]
[TD="align: center"] B
[/TD]

</TBODY>

I don’t have a preference for either VBA or a formula. I guess which ever is going to take the least on these junk office computers. The full Pivot Table is nearly 40 columns wide and 180 rows deep.</SPAN>