Combine Data

[Guest]

Hello..
How can i do this task?
I want to combine row in sheet1 and sheet 2..
i elaborate below:

lets say in sheet1 i got this data:
1 a a a a a
2 b b b b b
3 c c c c c
4 d d d d d
5 e e e e e

in sheet2 i got this data:
1 f f f f f
2 g g g g g
3 h h h h h
4 i i i i i
5 g g g g g

and i want to combine both data so it become like this
1 a a a a a
1 f f f f f
2 b b b b b
2 g g g g g
3 c c c c c
3 h h h h h
4 d d d d d
4 i i i i i
5 e e e e e
5 g g g g g


please help me....

 

[Leo Heuser]

Hello..
How can i do this task?
I want to combine row in sheet1 and sheet 2..
i elaborate below:

lets say in sheet1 i got this data:
1 a a a a a
2 b b b b b
3 c c c c c
4 d d d d d
5 e e e e e

in sheet2 i got this data:
1 f f f f f
2 g g g g g
3 h h h h h
4 i i i i i
5 g g g g g

and i want to combine both data so it become like this
1 a a a a a
1 f f f f f
2 b b b b b
2 g g g g g
3 c c c c c
3 h h h h h
4 d d d d d
4 i i i i i
5 e e e e e
5 g g g g g


please help me....

Hi John

One way assuming data in sheet1 and sheet2 in A1 and down
In A1 in sheet3:

=IF(MOD(ROW(),2),OFFSET(Sheet1!$A$1,(ROW()+1)/2-1,0),OFFSET(Sheet2!$A$1,ROW()/2-1,0))

Copy A1 down with the fill handle (the little square
in the lower right corner of the cell)

Similar for B1, C1 etc.