Split a value from a row into separate rows

[Luk88kk]

Good morning,
Could someone please help me to split a value from a row into separate rows.
It looks like this:

And this is how I would like it to look:

[AngelosPachis · Accepted solution]

Hi @Luk88kk ,

You can use a text to column tools to split to rows on every new line and then remove the commas from the right hand-side of the string.

[Luk88kk]

Thank you very much. It works great!
Happy New Year:)