Moving Row-Level Output data into Columns

I have a scenario where I need to move additional data in rows with the same primary key into additional columns. Below is a link to a shared Excel workbook via Dropbox that shows what the current format is, and my desired format:

https://www.dropbox.com/sh/p2t7cqm8u...Rw43WrUra?dl=0

If that link does not work, here is the file again as well: http://s000.tinyupload.com/index.php...98035882642708

I should also note that each candidate ID (roughly 100,000 unique IDs) may have more than 2 sets of education history--it could be any number, so the VBA script will need to account for those possibilities (i.e. run until candidate ID changes).
I'm hoping this is possible--the case for this is for a data migration between our legacy system & a new system that needs the data rolled up into additional columns.