Question - How to group unique objects in Excel
I have an Excel worksheet. There is a column with duplicate entries. I want
to be able to group by unique entries, but still keep the information tied to
the other columns. For example:
Column 1 Column2
Primary CE CA85
Secondary CE CA85
Secondary CE CA85
CE Group CK11
I want to group on Column 2 so that CA85 appears once, but there are still 3
entries in Column1.
Essentially, what I am looking for is an output of unique items similar to
what is displayed in the drop down list of column 2 if I was to use the Auto
Filter capability.
Any help this newsgroup could provide is much appreciated.
Thanks!
Brad
|