Transfer from several cells to a single cell, etc.

[Sal Iaccarino]

We have the following in our spread sheet:

NAME ADDRESS TELEPHONE Away Address Away City & State Away Zip Away
telephone
Alibrandi, Patricia 7455 Jacaranda Park Rd, S203 514-2840
Allard, Michael/Shirley Giquere 2635 Magnolia Park Ln, NY102 598-9268
57 Ridgetop Rd. Wallingford, CT 06492 203-265-3164
Allard, Raymond & Zalita 7436 Plumbago Bridge Rd, N203 566-7762 18
State Rd. Dannemora, NY 12429 716-532-0177
Allen, Philip & Marguerite 2615 Magnolia Park Ln, NW101 513-1771

We would like to prepare in the following format for a printed
telehone book. Can this be accomplished via a formula?
Would appreciate any suggestions to reduce work to accomplish this
format.
Thanks. I realize this isn't simple.
Sal and Eileen
NAME ADDRESS TELEPHONE
Alibrandi, Patricia 7455 Jacaranda Park Rd, S203 514-2840

Allard, Michael/Shirley Giquere 2635 Magnolia Park Ln, NY102 598-9268
57 Ridgetop Rd., Wallingford, CT, 06492 203-265-3164

Allard, Raymond & Zalita 7436 Plumbago Bridge Rd, N203 566-7762
18 State Rd., Dannemora, NY, 12429 716-532-0177

Allen, Philip & Marguerite 2615 Magnolia Park Ln, NW101 513-1771

 

[Sal Iaccarino]

Forget the following post. I sent as Html to lineup the cell columns. But I
see it was changed to plain text and it loses all of its meaning.

Thanks,
Sal and Eileen