J
john.9.williams
Hi i have 3 cells a1 a2 a3 all with about 2 sentences of data in, i
want to take all that data and put it in one cell, however i wish to
seperate each piece of data from each cell with a carrige line space
and title like below
go from this :
cell a1: helloe i am the data in a1
cell a2: hello i am the data in a2
cell a3: hello i am the data in a3
to this
cell b1: a1 data
hello i am the data in a1
a2 data
hello i am the data in a2
a3 data
hello i am the data in a3
hope this makes sense, been trying to solve this but cannot get the
line spaces or add the titles to each cell value
want to take all that data and put it in one cell, however i wish to
seperate each piece of data from each cell with a carrige line space
and title like below
go from this :
cell a1: helloe i am the data in a1
cell a2: hello i am the data in a2
cell a3: hello i am the data in a3
to this
cell b1: a1 data
hello i am the data in a1
a2 data
hello i am the data in a2
a3 data
hello i am the data in a3
hope this makes sense, been trying to solve this but cannot get the
line spaces or add the titles to each cell value