Zend certified PHP/Magento developer

Handling Columns With Multiple Values in Excel

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.