Hi all,
Is there a way to sort data in excel so if there's something like this:
a a a
a b b
a b c
b b c
c c c
it can turn into this with all the similar data grouped to show how many of
each type are in each column without it being mashed together?:
a a a
a
a
b b b
b
b
c c c
c
c
Thanks, I wasn't sure how else to put it without an illustration!
Bookmarks