How can I reformat some rows into columns in Excel?

[nijialagua]

I have a huge data. I want to reformat from

A 1
A 2
A 3
B 4
B 5
C 6
C 7
C 8
C 9

To
A 1 2 3
B 4 5
C 6 7 8 9

How can I do it?

Thank you for your help!

[temple1]

Try Copy and Transpose (from the Paste menu).

[nijialagua]

Thanks! But it doesn't work.
It will become:
A A A B B C C C C
1 2 3 4 5 6 7 8 9