Ok i hope i can explain this clearly. I am trying to get all the informaiton
about a particular customer on one line/row. I have information in A/B/C/D
columns. In the B column i have the customers Street address in one line and
then the city/state/zip is in the line below that.
Example
1st row - name in column a / company in column b/ state in column C / Lic.#
in D
2nd row - nothing in column a / st. address in column b/ nothing in column
C/ dito
3rd row - nothing in column a / city,state,zip in colum b/ nothing in column
C/ dito

*So you see in column b is everything i need to be in order in the 1st row
to be able to make labels. I have no need for 2nd/3rd row but the source i
imported it from put it into this format.
Thanks and I hope there is a solution to my problem
Holly