Thread: Merge two lists
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming
Murtaza Murtaza is offline
external usenet poster
 
Posts: 12
Default 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