Manipulating Horizontal Data to Vertical Data? (Excel 2003 )

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote