View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jezzica85
 
Posts: n/a
Default Sorting in multiple columns

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!