Grouping data columns by shared values
- by Lenna
I don't know how to properly describe what I need to do, so I will give an example. A colleague has a data set in Excel like so:
Col A Col B Col C
aaaaa aaaaa bbbbb
bbbbb ccccc ccccc
ccccc ddddd eeeee
The end result should be something like this:
Col A Col B Col C
aaaaa aaaaa
bbbbb bbbbb
ccccc …