Duplicate rows if cell contains carriage return (or possibly newline)

[matybg]

Hi,

I would like to know how I can duplicate a row if a cell in a particular column has multiple values separated by a carriage return (or maybe its an endline not sure). My data looks something like this:

uniquetext_A text1
text2
uniquetext_B text1
uniquetext_C text1
text2
text3

and the result would ideally be:

uniquetext_A text1
uniquetext_A text2
uniquetext_B text1
uniquetext_C text1
uniquetext_C text2
uniquetext_C text3


I've already tried this:

Please Login or Register  to view this content.

And I'm having partial success, with problems though.
Here are my before-after macro pictures of the sheet, and also a link to the original file.

Original: https://drive.google.com/open?id=0B6...kYyTU9XLV9HQ2M
Post-Macro: https://drive.google.com/open?id=0B6...WdRY29IWGZxd28

Original File: https://drive.google.com/open?id=0B6...21raWpuTUI5STA

Regards!

[pjwhitfield]

Im unable to open google drive docs due to our firewall can you upload the workbook?