Merge two lists
 

I have 2 sets of data range i.e set1 from range [Sheet1!A1:A32] and set2 is
from [Sheet2!B1:B32]

Set1 contains Vegetables List
Set2 contains Fruits List

Now I want to merge both lists in [Sheet3! C1:C64] but one value from set1
and one value from set2

Below is graphical translation:

SET1
A1: Tomatto
A2: Cucummber
A3: Carrott
...............so on


SET2
B1: Apple
B2: Oranges
B3: Bananna
...............so on


SET3 [to create]
C1: Tomatto
C2: Apple
C3: Cucummber
C4: Oranges
C5: Carrott
C6: Bananna
...............so on

Please help

Merge two lists
 

If indeed the sheets are called 1 and 2 you can use this in C1 and copy down

=OFFSET(INDIRECT("'Sheet"&MOD(ROW(2:2),2)+1&"'!A1" ),FLOOR(ROW(2:2)/2,1)-1,MOD(ROW(2:2),2))

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Murtaza" <NoEmail@NoEmail wrote in message
...
I have 2 sets of data range i.e set1 from range [Sheet1!A1:A32] and set2
is
from [Sheet2!B1:B32]

Set1 contains Vegetables List
Set2 contains Fruits List

Now I want to merge both lists in [Sheet3! C1:C64] but one value from set1
and one value from set2

Below is graphical translation:

SET1
A1: Tomatto
A2: Cucummber
A3: Carrott
..............so on


SET2
B1: Apple
B2: Oranges
B3: Bananna
..............so on


SET3 [to create]
C1: Tomatto
C2: Apple
C3: Cucummber
C4: Oranges
C5: Carrott
C6: Bananna
..............so on

Please help

Merge two lists
 

Thanks Peo!

"Peo Sjoblom" wrote in message
...
If indeed the sheets are called 1 and 2 you can use this in C1 and copy
down


=OFFSET(INDIRECT("'Sheet"&MOD(ROW(2:2),2)+1&"'!A1" ),FLOOR(ROW(2:2)/2,1)-1,MO
D(ROW(2:2),2))

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)



"Murtaza" <NoEmail@NoEmail wrote in message
...
I have 2 sets of data range i.e set1 from range [Sheet1!A1:A32] and set2
is
from [Sheet2!B1:B32]

Set1 contains Vegetables List
Set2 contains Fruits List

Now I want to merge both lists in [Sheet3! C1:C64] but one value from
set1
and one value from set2

Below is graphical translation:

SET1
A1: Tomatto
A2: Cucummber
A3: Carrott
..............so on


SET2
B1: Apple
B2: Oranges
B3: Bananna
..............so on


SET3 [to create]
C1: Tomatto
C2: Apple
C3: Cucummber
C4: Oranges
C5: Carrott
C6: Bananna
..............so on

Please help