Help! Moving multiple rows to columns in large sheet

[alay]

Hello,
I'm a newbie. Please excuse my ignorance as I try to make sense!~

I have a large sheet with a lot of data. (33 Columns, thousands of rows) Column A contains ID #s. There are multiple duplicates as each id# is enrolled in multiple programs (listed in column B). Column C and D represent enrollment and exit dates.

I need to transfer the values of Column B (program enrollments) to multiple columns that correspond to the values of column A (ID #s) and C and D (enrollment and exit dates, correspondingly).

Sample attached. Hopefully someone can help.

[Glenn Kennedy]

Delete all expected results.

Please Login or Register  to view this content.

Adust the ranges in ID,Dat and Oth. Otherwise, it should do it all in one go,