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:

[TABLE="class: grid, width: 100, align: left"]
<tbody>[TR]
[TD]Store[/TD]
[/TR]
[TR]
[TD]Kroger[/TD]
[/TR]
[TR]
[TD]Kroger[/TD]
[/TR]
[TR]
[TD]Kroger[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="class: grid, width: 100, align: center"]
<tbody>[TR]
[TD]Item[/TD]
[/TR]
[TR]
[TD]Apples
Bananas
Oranges[/TD]
[/TR]
</tbody>[/TABLE]




To this:

[TABLE="class: grid, width: 200, align: center"]
<tbody>[TR]
[TD]Store[/TD]
[TD]Item[/TD]
[/TR]
[TR]
[TD]Kroger[/TD]
[TD]Apples[/TD]
[/TR]
[TR]
[TD]Kroger[/TD]
[TD]Bananas[/TD]
[/TR]
[TR]
[TD]Kroger[/TD]
[TD]Oranges[/TD]
[/TR]
</tbody>[/TABLE]


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.