We collect sets of alphanumeric values called variants through an online form, the output of which is presented in an Excel spreadsheet. The base product has a set of Base Variants. Options can be added to the base product. Each option has its own set of variants, which are collected into multiple cells with label "ADD Variants". I have added an image of a sample file with Base variant, 2 ADD Variants and 2 REMOVE Variants: Screenshot
My requirements are as follows:
- All values from ADD Variants cells need to appended to Base Variants list. Values from multiple REMOVE Variants are looked up and are deleted from Base Variants (Base Variants + ADD Variants - REMOVE Variants)
- Finally, I need a string of Base Variants, each of them delimited by a Comma and a single space, which can be copied and pasted into our supplier's ordering portal. This will bring up the product with the chosen options added in the portal.
Can someone help with how the above could be achieved? I also need to automate this process. Any help is hugely appreciated!
Split()
function.