Split one column to "N" number of rows based on comma

danbzz

Hi everyone!

I have a column with several words delimited by a comma. I would like to split each word into a new row and achieve the below result. The number of words under column "Column2" may vary. Would you be able to help me with this? Any input would be much appreciated.

Column1	Column2
value1	word1, word2, word3
value2	word1, word2, word3, wordN

Expected output:

Column1	Column2
value1	word1
value1	word2
value1	word3
value2	word1
value2	word2
value2	word3
value2	wordN

binu_acs

@danbzz you can achieve this by using the text to column tool. You need to select the split to rows option

text_to_column_10_05.yxmd