labels to list
 

I have a worksheet that has labels in it. A1 is the first name and last
names of the peaple, A2 has street address, A3 has city, state, zip, and A4
has telephone #, not all of address have a telephone #. Column B:B is empty
C1 has first name and last names and column c1,d1,e1,f1,g1 are joined, C2
has street address, c2,d2,e2,f2,g2 are joined. C3 has city, state, zip,
c3,d3,e3,f3,g3 are joined. same thing happens with column h-m.

so 1 column a:a, columns 2 joined c-g, column 3 joined h-m
I would like to take the address with 3 to four lines and turn each one into
a row of address.

Thank You

Gary Reger