Help with Concatence and Pivot Tables

mdiangelo

New Member
Joined
Mar 25, 2013
Messages
4
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>

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

<TBODY>
</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>
 

Forum statistics

Threads
1,081,702
Messages
5,360,743
Members
400,595
Latest member
T_Dubs

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top