I have an Excel table that looks like this:
id | favorite fruits |
---|---|
1 | apples, bananas |
2 | strawberries, bananas |
3 | kiwis, apples |
I would like to have each fruit in a different row like so:
id | favorite fruits |
---|---|
1 | apples |
1 | bananas |
2 | strawberries |
2 | bananas |
3 | kiwis |
3 | apples |
Any idea how to achieve that?
Thanks.