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

Please Login or Register  to view this content.

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

Please Login or Register  to view this content.

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

This little macro will create an "Output" list sheet and populate it based on the field names in column A and the values in column B. The field names DO have to be accurate.

Please Login or Register  to view this content.