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 |
Solved! Go to Solution.
@danbzz you can achieve this by using the text to column tool. You need to select the split to rows option
That was easier than expected. Thanks @binuacs !