Merging cells to copy and paste, without using mailmerge

[dyanblak]

Hi , I wonder if anybody can help?
I need to prepare a table that merges names and addresses into one cell so that it can be copied and pasted onto eg a label.
Unable to use mailmerge as not all users are familiar will this so want to keep it simple.
Ideally I would like a formula to use in column I. At the moment I have copied and pasted each cell and entered alt with enter to get the next row, which is obviously time-consuming
Any advice greatly appreciated. Spoof names and addresses used here:

Sign Up Date	Customer Name	Address 1	Address 2	Address 3	Address 4	Address 5	Postcode	To copy and paste into corres, labels etc
19/03/2014	John Smith	56 Tower House	Wandsworth Lane	Lambeth	London		SW6 5ET	John Smith 56 Tower House Wandsworth Lane London SW6 5ET
08/04/2014	Cheryl Jones	3 Kings Road	Ramsgate	Kent			CH11 6LN
07/05/2014	Valerie Patisserie	14 Hill Rise	Haprenden	Hertfordshire			AT5 4SN
12/05/2014	David Evans	27 Bell Road	Retford	Nottingham			DN21 5PF

 

[Fluff]

Glad we could help & thanks for the feedback.