Inverse of Merge, or text to ROWS.

[Loueloui]

Hello all,
I have a question I have not seen answered yet, and I have no idea how to accomplish this. I have some data which shares some common elements, but has unique values. Some cells have multiple items separated by a linefeed (Alt+Return) as in the description column.
For example I would like to convert This:

Into this:

I could do a text to columns and transpose it, and then repaste it however this is cumbersome, and my list is quite long. Is there any way to do this without a complicated, mufti-step solution?

 

[Loueloui]

Sorry, Images did not come out.

I want to go from this:

Store

Kroger

Kroger

Kroger

<tbody>
</tbody>

Item

Apples Bananas Oranges

<tbody>
</tbody>

To this:

Store	Item
Kroger	Apples
Kroger	Bananas
Kroger	Oranges

<tbody>
</tbody>

Note that the 'Items' is a list in a single cell. I need to paste this to individual cells in the same column using the linefeed as a delimiter.