How to move data from one cell into a different column but have the associated data attached follow.

[151966]

[TABLE="width: 607"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Smith[/TD]
[TD]Jen[/TD]
[TD]Breakout_Session_1[/TD]
[TD]I can read with my eyes[/TD]
[/TR]
[TR]
[TD]smith[/TD]
[TD]Jen[/TD]
[TD]Breakout_Session_2[/TD]
[TD]Wedo [/TD]
[/TR]
[TR]
[TD]smith[/TD]
[TD]Jen[/TD]
[TD]Breakout_Session_3[/TD]
[TD]App Safari[/TD]
[/TR]
[TR]
[TD]Black[/TD]
[TD]Kay[/TD]
[TD]Breakout_Session_1[/TD]
[TD]Multimodal Magic [/TD]
[/TR]
[TR]
[TD]Black[/TD]
[TD]Kay[/TD]
[TD]Breakout_Session_2[/TD]
[TD]Digital Pets[/TD]
[/TR]
[TR]
[TD]Black[/TD]
[TD]Kay[/TD]
[TD]Breakout_Session_3[/TD]
[TD] Kitchen number 1[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Skybluekid]

Could you explain your problem further.

 

[151966]

I have some data which comes of a website of students whom are selecting their sessions to attend at the conference. In the Surname column i have the list of the names and there is multiple rows entered with the same name each with a session selection. I need to create a mail merge using this data to have only the name and their sessions on a name badge. I need to manipulate this data to reflect a single line in the sheet showing their name and in 3 new columns for each session and their selection.

 

[Skybluekid]

What version are you using, 2003, 2007 or 2010?

 

[151966]

What version are you using, 2003, 2007 or 2010?

I am using 2010