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

[151966]

Smith	Jen	Breakout_Session_1	I can read with my eyes
smith	Jen	Breakout_Session_2	Wedo
smith	Jen	Breakout_Session_3	App Safari
Black	Kay	Breakout_Session_1	Multimodal Magic
Black	Kay	Breakout_Session_2	Digital Pets
Black	Kay	Breakout_Session_3	Kitchen number 1

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

 

[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