Combining rows

[Brenda]

Hello everybody!

I need assistance in combining two rows of data into
one. The way the current layout is as follows:

Name Address City
State Zip
Name Address City
State Zip

But I need it to look like this:

Name Address City State Zip
Name Address City State Zip

Each cell remaining seperate (no concatenation), if that
makes sense. I've looked into the Snake Columns, but I'm
thinking that does not apply.

TIA,
Brenad

 

[Ken Wright]

Are Name / Address / City each in their own cell, so you have 3 cells of this and two
cells of State / Zip below

A B C
1 Name Address City
2 State Zip
3 Name Address City
4 State Zip

Wanted:-
A B C D E
1 Name Address City State Zip
2 Name Address City State Zip

 

[Ken Wright]

Assuming they are:-

In cell D1:H1 which are currently blank:-

D1 =OFFSET($A$1,(ROW()*2)-2,)
E1 =OFFSET($B$1,(ROW()*2)-2,)
F1 =OFFSET($C$1,(ROW()*2)-2,)
G1 =OFFSET($A$1,(ROW()*2)-1,)
H1 =OFFSET($B$1,(ROW()*2)-1,)

Select D1:H1, copy and then paste down as far as you need (Halfway down yoir current
list).

When done, select D1:H??, and then do Edit / Copy, then Edit / Paste Special / Values.
You shoudl now be able to delete the original 3 columns, leaving you just the data you
want.

 

[Brenda]

Yes, they are each in their own cell, 3 cells in row one
and 2 cells in row two.

Thanks,
Brenda

 

[Ken Wright]

See my follow-up note for an answer.