Split a single column into multiple rows based on a delimiter
I have a column with a variable number of items, delimited by a comma. For example: column_a: 1,2,3,4 Number of elements is variable - it can be a single element, or 50 (while I can set an upper limit, it can be dozens). I need a way to split the data in the column into rows, so with the above example I'd like to have:…
