View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
scott scott is offline
external usenet poster
 
Posts: 577
Default Sort/Reference formula help needed.

Currently I have a data sheet that looks like this:

_____A_____B_____
1 A Data 1
2 B Data 2
3 A Data 3
4 C Data 4
5 B Data 5

I want to create a column that will sort and display and list all of the
"A's" in Column A, all of the "B's" in another column, all of the "C's" in
another column, and so on.

Basically I want it to read like this:
A B C
Data 1 Data 2 Data 4
Data 3 Data 5

How do I go about accomplishing this?