Currently have a one column custom SQL table that has multiple entries per row, separated by a new line. I would like to be able to split or break apart the multiple values so we are left with one normalized table/column that has all of the unique values. Any ideas?
Table looks like...
What I would like to get to is this, in a new table.
Any ideas on how this could be done?
Please sign in to leave a comment.