transform data separated with comma into 1 column

Hi guys,

I would like to ask the more experienced ones how to deal with the following problem:

In B1, I have several text strings separated by comma and blank space

Please Login or Register  to view this content.

I would like to transform this text into the column A so there will be one word at a line

Please Login or Register  to view this content.

The original file contains about 500 word in B1 so if there is an elegant way how to achieve that, it would save me a lot of time.

Thank you, any help will be appreciated.
samplefile.xlsx

Try this one too...

Please Login or Register  to view this content.