Transposing columns to rows

Dear Excel Gurus,

I am quiet new to this world and am having some problems in achieving a particular requirement that i have.

My Problem
-----------
I have a worksheet in which there are 2 columns, one containing the field names and the other containing the values.
Example

 Column1            Column2
 --------------------------
 Name                John
 Age                 23
 City                London
 Country             UK
 Name                Sunita
 Age                 23
 City                Bangalore
 Country             India

I want to move this to another worksheet and it should look in the following manner

 Name      Age     City       Country
 -------------------------------------
 John      23      London     UK
 Sunita    23      Bangalore  India

Can you please let me know how i can achive this.

To add to my problems the field names will not be constant i.e Column 1 might have 5 occuances of the set Name,Age,City, COuntry and can also ahve Name,Age,Country

How can i handle this.

Thanks in advance!!

Sunita