Create macro to convert rows attributes to column headers and vv

  • Thread starter Thread starter T.Vidak
  • Start date Start date
T

T.Vidak

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
 
Should post this question in an Excel newsgroup, this one is for FrontPage
 
Back
Top