M
Murtaza
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
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