Moving Row-Level Output data into Columns

**burghman787** · 02-03-2017, 10:27 AM

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.

**Pete_UK** · 02-03-2017, 10:44 AM

Many contributors are unwilling (or unable due to company firewalls etc.) to download files from 3rd party sites. However, you can attach files to your posts here on the Forum - here's what to do:

First of all, prepare a SAMPLE file - this only needs a few records which are representative of the variations in your data, but the sample file should have the same structure as your main file, and could include a Before and After sheet showing exactly what you want to achieve. Then you can:

Click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and then on Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Please note that the Paperclip icon does not work.

Hope this helps.

Pete