Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Create a new set of data from 2 data sets
I have 2 list of data and I need a formula that can create a new data set by merging the 2 list of data.
For example: Data set 1: Country Name: Malaysia, Singapore, China, Taiwan Data set 2: Stock List: Apple, Orange, Pear, Melon, Carrot Merged data - 2 columns (Country and Stock list) Country Stock List Malaysia Apple Malaysia Orange Malaysia Pear Malaysia Melon Malaysia Carrot Singapore Apple Singapore Orange Singapore Pear Singapore Melon Singapore Carrot China Apple China Orange China Pear China Melon China Carrot Taiwan Apple Taiwan Orange Taiwan Pear Taiwan Melon Taiwan Carrot Both data set are dynamic, i.e. the lists are likely to change over time. Can this be done without using VB script? Many thanks in advance. Last edited by CS Chia : August 26th 13 at 03:07 AM |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Create 3rd data set off comparison of 2 other sets | Excel Worksheet Functions | |||
using excel to create data sets | Excel Discussion (Misc queries) | |||
how do i create a chart with 4 sets of data? | Charts and Charting in Excel | |||
how to create a line-chart with 2 sets of data who has different x | Charts and Charting in Excel | |||
Create programmatically list of combinations for choices from data sets in excel vba | Excel Programming |