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.