I have the attached spreadsheet with two columns of data - the first with a single value (col A) in and the second (col B) with either no value, a single value or multiple values with many values in separated by a comma (all multiple values are separated by a comma).
I could like to keep Col A as it is however I would like all the values in column B to be separated (if there are multiple in a cell) and copied to column A as single values or just copied to column A where there is a single value (i.e. no comma indicating multiple values) and just ignored if no value.
Could someone tell me if this is possible and how I may tackle this?
Do you have a constant delimiter like you said in your question comma or it will be always like this??