L
LizE
I have a list of addresses that are all in one column but they are not equal
in lenght, some have 3 lines and others have 4 lines, there is no row
separating each record. I would like to use this data for mailing list. So
I'd like to see the information as follows:
Name Address 1 Address 2 City/St/Zip
I know how to break up the City/ST/Zip data.
Transpose works but I have to do each group separately and it's taking me
forever.
Thanks for your help.
in lenght, some have 3 lines and others have 4 lines, there is no row
separating each record. I would like to use this data for mailing list. So
I'd like to see the information as follows:
Name Address 1 Address 2 City/St/Zip
I know how to break up the City/ST/Zip data.
Transpose works but I have to do each group separately and it's taking me
forever.
Thanks for your help.