re-arranging the data

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!

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!
>

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
"Dave F" wrote:

> 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!
> >