I'm hoping someone can help with manipulating data from one column to multiple rows and cells in an easy fashion. We copy and paste hundreds of names for mailing lists into one column in the format you see below. We are trying to quickly convert the data so that if Name One is in cell a1, then address one would move to b1, city to c1, state to d1 and zip to e1. Then if name two is in cell a4, then address two would move to b4, city to d4 and zip to e4. I know about the transpose function but it is far too time consuming to do that over and over for the number of entries we need to address. Anything faster would be much appreciated. Thanks!
<colgroup><col style="mso-width-source:userset;mso-width-alt:5728;width:134pt" width="179"> </colgroup><tbody>
<colgroup><col style="mso-width-source:userset;mso-width-alt:5728;width:134pt" width="179"> </colgroup><tbody>
[TD="class: xl65, width: 179"]Name One[/TD]
[TD="class: xl65"]Address One[/TD]
[TD="class: xl65"]City, State, Zip[/TD]
[TD="class: xl65"]Name Two[/TD]
[TD="class: xl65"]Address Two[/TD]
[TD="class: xl65"]City, State, Zip[/TD]
[TD="class: xl65"]Name Threee[/TD]
[TD="class: xl65"]Address Three[/TD]
[TD="class: xl65"]City, State, Zip[/TD]
</tbody>
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
</tbody>
<colgroup><col style="mso-width-source:userset;mso-width-alt:5728;width:134pt" width="179"> </colgroup><tbody>
<colgroup><col style="mso-width-source:userset;mso-width-alt:5728;width:134pt" width="179"> </colgroup><tbody>
[TD="class: xl65, width: 179"]Name One[/TD]
[TD="class: xl65"]Address One[/TD]
[TD="class: xl65"]City, State, Zip[/TD]
[TD="class: xl65"]Name Two[/TD]
[TD="class: xl65"]Address Two[/TD]
[TD="class: xl65"]City, State, Zip[/TD]
[TD="class: xl65"]Name Threee[/TD]
[TD="class: xl65"]Address Three[/TD]
[TD="class: xl65"]City, State, Zip[/TD]
</tbody>
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
</tbody>