Hi everyone, I would love so help with an expression. I have attached a spreadsheet which outlines the input, desired output, and an approach I am considering. Here is a summary of the issue (which is the same as what is in Excel too)
One approach I am thinking of is:
After applying the "+" delimiter to parse out the data to the following, add a formula to the data such that, if there is no space before the comma, the original string (e.g., "TCL") repeats itself with a space in between (following the same example, it becomes "TCL TCL").
If anyone could please provide some pointers with the expression I would really appreciate it. If you have another easier approach, I would love to hear it too. Thank you so much!!
