Forum Discussion
Split text string column values into multiple rows at a position relative to a delimiter
Hello, I need to split the values in the Notes column (see BEFORE) into a separate row for each note (see AFTER). A new note begins when a timestamp occurs in the text string. The timestamp follows...
I have a similar question, but I have two columns I need to split into their own rows whenever the date/time stamp appears since each starts its own note. I'm assuming I'd have to do the first column and then the second? Also, I'm not clear on the instructions provided below, as it doesn't seem to be working to separate my data. Any help would be appreciated.