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

Dave

"Lan" wrote:

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!