Moving Row-Level Output data into Columns

[burghman217]

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 two photos to reflect what the current data output looks like and how I will need it to appear:

Education & Work History - Album on Imgur

Basically, I need the data from each row to roll up into separate, repeating columns based upon the primary key, Candidate ID. Is this possible?

 

[burghman217]

[TABLE="class: outer_border, width: 500"]
<tbody>[TR]
[TD][TABLE="width: 128"]
<tbody>[TR="class: outer_border"]
[TD="width: 128"]CURRENT FORMAT[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 128"]
<tbody>[TR="class: outer_border"]
[TD="width: 128"]Candidate ID[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR="class: outer_border"]
[TD="width: 186"]School[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR="class: outer_border"]
[TD="width: 88"]Degree Type[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 105"]
<tbody>[TR="class: outer_border"]
[TD="width: 105"]Degree[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR="class: outer_border"]
[TD="width: 71"]Grad Year[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 128"]
<tbody>[TR="class: outer_border"]
[TD="width: 128, align: right"]30[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR="class: outer_border"]
[TD="width: 186"]George Washington University[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR="class: outer_border"]
[TD="width: 88"]Doctorate[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 105"]
<tbody>[TR="class: outer_border"]
[TD="width: 105"]Political Science[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR="class: outer_border"]
[TD="width: 71, align: right"]2010[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 128"]
<tbody>[TR="class: outer_border"]
[TD="width: 128, align: right"]30[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR="class: outer_border"]
[TD="width: 186"]RUTGERS COLLEGE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR="class: outer_border"]
[TD="width: 88"]Bachelors[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 105"]
<tbody>[TR="class: outer_border"]
[TD="width: 105"]Political Science[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR="class: outer_border"]
[TD="width: 71, align: right"]2005[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 128"]
<tbody>[TR="class: outer_border"]
[TD="width: 128"]DESIRED FORMAT[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 128"]
<tbody>[TR="class: outer_border"]
[TD="width: 128"]Candidate ID[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR="class: outer_border"]
[TD="width: 186"]School[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR="class: outer_border"]
[TD="width: 88"]Degree Type[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 105"]
<tbody>[TR="class: outer_border"]
[TD="width: 105"]Degree[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR="class: outer_border"]
[TD="width: 71"]Grad Year[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 136"]
<tbody>[TR="class: outer_border"]
[TD="width: 136"]School[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR="class: outer_border"]
[TD="width: 88"]Degree Type[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 105"]
<tbody>[TR="class: outer_border"]
[TD="width: 105"]Degree[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR="class: outer_border"]
[TD="width: 71"]Grad Year[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 128"]
<tbody>[TR="class: outer_border"]
[TD="width: 128, align: right"]30[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 186"]
<tbody>[TR="class: outer_border"]
[TD="width: 186"]George Washington University[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR="class: outer_border"]
[TD="width: 88"]Doctorate[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 105"]
<tbody>[TR="class: outer_border"]
[TD="width: 105"]Political Science[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 71"]
<tbody>[TR="class: outer_border"]
[TD="width: 71, align: right"]2010[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 136"]
<tbody>[TR="class: outer_border"]
[TD="width: 136"]RUTGERS COLLEGE[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 88"]
<tbody>[TR="class: outer_border"]
[TD="width: 88"]Bachelors[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 105"]
<tbody>[TR="class: outer_border"]
[TD="width: 105"]Political Science[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD] [TABLE="width: 71"]
<tbody>[TR="class: outer_border"]
[TD="width: 71, align: right"]2005[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]


I decided to go the long way--figured it would be easier. I'm hoping the above scenario makes sense?

 

[hiker95]

burghman217,

I can not tell where your raw data is located, sheet name(s), cells, cell formatting, cell formulae, rows, columns, and, we can not tell where the results should be, sheet name, cells, cell formatting, cell formulae, rows, columns.


See:

B. Posting Aids at the next link:

https://www.mrexcel.com/forum/board-announcements/127080-guidelines-forum-use.html

I use the MrExcel HTML Maker