I have a huge spreadsheet of data from questions on 5 different things. How
do I sort the data. I know there is a function like vlookup to help me do
this but i dont know what it is. My data looks like

A 1 2 3
A 4 5 6
B 1 2 2
C
D
A...... You see what I mean. I want to group all the A's,
B's etc together in a new sheet (so that i can do the average, standard
deviation etc) so I need excel to go from row to row, searching for all the
A's and for each A that it finds transfer all of the data in that row. How do
I do that?
Thank you