Consolidating Text Data rom a Sheet

[pr4peace]

Hi,


Is it possible to consolidate text data like we consolidate numerical data in pivot table.


Example :-


COl A COL B


ABC A

CDE B

FGH C

XYZ A


Is it possible to summarize all corresponding data to 'A'. Not by using Sort but into a separate sheet which is automatically updated as we update the master table. I tried pivot table , but that it limited to mathematical and statistical funtions. Using vlookup gives only the first result(also the COLUMNS are in the reverse order for vlookup to work).


Any help would be deeply appreciated.


Many thanks in advance.

 

[Kyle McGhee]

A pivot table would work. In the row labels field box, drag column B, then column A underneath.


The result will look similar to this:

[pre]

A
ABC
XYZ
B
CDE
C
FGH

[/pre]
It will only show uniques as well, e.g. if ABC A was in the data twice, it would only show once in the pivot. You will need to manually refresh the pivot or create a macro to auto-update it.

 

[pr4peace]

Hey Kyle McGhee,


That was soo simple, I felt stupid !!!


Thanks a ton. I have been so worried that Pivots cant do text that I did not see that.


Thanks again