re-arranging the data

L

Lan

I have a table, which contains the data in a format like this:

group ID # of office visit
A 5
A 9
B 5
B 6
A 7


I want to re-arrange the data, so I can calculate the median, mean, and mode
of each group in excel using the data analysis tool.

I want the dat to look like this:
A B
5 5
9 6
7

How can I do that?

Thanks!
 
D

Dave F

Select the range of data you're looking to rearrange, copy, paste special,
transpose.

Dave
 
L

Lan

That is not the result I want.
If I copy, paste special, and transpose, the result would be:
A A B B A
5 9 5 6 7

I want:
A B
5 5
9 6
7

Thanks
 
Top