Moving One Column To Multiple Rows and Multiple Cells

[cartley]

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>

Name One

Address One

City, State, Zip

Name Two

Address Two

City, State, Zip

Name Threee

Address Three

City, State, Zip

<colgroup><col style="mso-width-source:userset;mso-width-alt:5728;width:134pt" width="179"> </colgroup><tbody>
</tbody>

</tbody>

 

[Peter_SSs]

Thank you for that insight. This was a 1500 cell workbook they were trying to run the macro on and one address was missing a zip code. As soon as we added that in everything works great once again. Thanks for your help!

You are welcome. Glad it helped point you in the right direction.