Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merge two lists to get one with unique records | Excel Discussion (Misc queries) | |||
compare and merge lists in separate worksheets | Excel Worksheet Functions | |||
help with vlookup to merge two lists | Excel Discussion (Misc queries) | |||
Merge/Combine address lists | Excel Worksheet Functions | |||
How can I merge different lists in Excel? | Excel Discussion (Misc queries) |