[Google Sheet] Need help with the SPLIT and TRANSPOSE functions

[xROGERx]

This is a sample sheet with the content I need help with..

https://docs.google.com/spreadsheets/d/1-hsAbsf3z8w7rQ0LybGEY-xVt9ZWDlKcz1qZV0st00o/edit#gid=0

What´s there?

In column A, you see a standard outline for a blog post.

The outline is structured as follows...

1. All subheadings (H2) from the outline are shown with a bulleted point
2. Below it, you will see the talking points needed to write each subsection. These are written in a single line separated 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,

Been testing multiple formulas like SPLIT and TRANSPOSE and even a combination of them without luck.

Thoughts?

 

[Peter_SSs]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: [Google Sheet] Need help with the SPLIT and TRANSPOSE functions
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.