Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2006
    Location
    Princeton, New Jersey, USA
    Posts
    81
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Manipulating Horizontal Data to Vertical Data? (Excel 2003 )

    Hi All,

    I have an excel file that could have 100s of rows in this format:

    Pt No, Initials, V1, V2, V3, Vn (as the column headings)
    001, abc, date1, date2, date3, daten (as the records/rows)

    what I want is

    Pt No, Initials, Visit Name, Visit Date (as the column headings)
    001, abc, V1, Date1
    001, abc, V2, Date2
    001, abc, V3, Date3
    001, abc, Vn, Daten

    Can this be done using a Pivot Table (I tried, with no success) or VBA and if anyone can provide any help, I would really appreciate it!

    Thanks,
    --cat

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Manipulating Horizontal Data to Vertical Data? (Excel 2003 )

    You could use the macro from <post:=621,531>post 621,531</post:> as a starting point. It would have to be modified for your situation, but it gives the basic idea.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •