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.