How do I merge two cells in Excel

[Alan Fern]

I have a spreadsheet that I need to join the data from two cells into one:

i.e..

row 1 has data in column a,b,c,d and e
row 2 only has data in column c
row 3 is blank
row 4 has data in column a,b,c,d and e
row 5 only has data in column c
row 6 is blank

it continues as above throughout the spreadsheet.

what I need to do is merge the data in say row 1c with the data in row 2c.
Then continue through the whole on the spreadsheet i.e.. row4 c with data in
row5c.

Can anyone help with this problem.

Thanks, Alan

 

[Dave Smith]

One way:

A B C D E
1 sfdf ewrw hghh rter rete
2 rete
3
4 ertr sfsd dfiu uoew uoud
5 jldu
6


in G1 enter

=IF(ISBLANK(OFFSET($A$1,ROW()*3-3,0)),"",OFFSET($A$1,ROW()*3-3,0))

copy G1 to H1, J1, and K1
in I1 enter

=IF(ISBLANK(OFFSET($C$1,ROW()*3-3,0) &
OFFSET($C$1,ROW()*3-2,0)),"",OFFSET($C$1,ROW()*3-3,0) &
OFFSET($C$1,ROW()*3-2,0))

copy G1:K1 down.

If you need to get rid of the formulas and keep the values, you can Copy and
Paste Special > Values.

-Dave