Create macro to convert rows attributes to column headers and vv

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 Used as Column Headers (i.e. Titles)
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


Thanks for your help

Rob
Wed Jul 02 13:26:09 CDT 2008

Should post this question in an Excel newsgroup, this one is for FrontPage



--
~~~~~~~~~~~~~~~~~~
Rob Giordano
Microsoft MVP Expression






"T.Vidak" <T.Vidak@discussions.microsoft.com> wrote in message
news:195AD5DD-E5A1-46F1-947C-18A75253B519@microsoft.com...
> 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 Used as Column Headers (i.e. Titles)
> 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
>
>
> Thanks for your help
>