This worked really well! I need to extend the idea. I have a field where I don't know the number of delimited values (in one case up to 800 times). In my case, I have a column named "Group": - Row 1 has the values of "a, x, r, f" - Row 2 has the values of "r, b, a, q, g, 8" - Row 3 has the value of "s" I'd like it to create: Row 1 New Column of Group_1 with the value of "a" Row 1 New Column of Group_2 with the value of "x" Row 1 New Column of Group_3 with the value of "r" Row 1 New Column of Group_4 with the value of "f" ..... Row 3 column created above Group_1 with the value of "s" and all other New Columns would be blank. I've been trying a "do" statement using the scan to iterate up the Goup_# and then use it again as the scan number, but it's alluding me. 🙂 Thanks in advance!
... View more