This is a sample sheet with the content I need help with..
What?s there?
In column A, you see a standard blog post outline.
The outline is structured as follows...
The outline's subheadings (H2) are shown with a bulleted point, while each of the talking points needed to write those subheadings are below, in a single line with a comma as a delimiter.
What do I want to do?
I want to separate them, so they are shown in an individual cell.
Basically, one subheading per cell and all the talking points in another.
Just as shown in the first row on the TEST Sheet I share above.
Been testing multiple formulas like SPLIT and TRANSPOSE and even a combination of them without luck.
Thoughts?
Thanks ina advance!
Bookmarks