I am using excel 2003

I have a file like below
Rate month GBP
1.46 FEB 2000
1.47 MAR 3000
1.47 APR 3500
1.48 MAY 1000

I want to create summary
Rate FEB MAR APR MAY
1.46 2000
1.47 3000 3500
1.48 1000

I can use sumif function to return the total, however, how can I insert only
the unique rate in the first column automatically.

Thanks a lot !
eva cheng