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

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
news:ewT2Dd%(E-Mail Removed)...
>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
>
>

Thanks Peo!

"Peo Sjoblom" <(E-Mail Removed)> wrote in message
news:uhQTYd$(E-Mail Removed)...
> 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
> news:ewT2Dd%(E-Mail Removed)...
> >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
> >
> >
>
>