Hi,
I would like to build a macro to convert a table from rows to columns. The
initial spreadsheet is set up so that each row represent one piece of
information for the same ID. For each ID there are 5 rows

A B C
ID1 Name Smith
ID1 Address 22 Smith rd.
ID1 Date of Birth 1987/12/07
ID1 Country of Birth Canada
ID1 Nationality Canadian
ID2 Name Brown
ID2 Address xxBrown st.
ID2 Date of Birth 1965/01/12
ID2 Country of Birth USA
ID2 Nationality Canadian

The new worksheet should display the information by ID while the attributes
listed in column B should be displayed in the Header row (as Column Headings)
ID Name Address Date of Birth Country of Birth
Nationality
ID1 Smith XX Smith rd 1987/12/07 Canada
Canadian
ID2 Brown XX Brown rd 1965/01/12 USA
Canadian