How can I Split multiple entries in a single cell seperated by CHAR(10) for easy lookups

Hi Guys

I've found a few solutions to extracting and splitting multiple data entries on one cell and separated by Carriage Returns, but can't get a routine that splits across the existing and a new row and copies the surrounding data so it will still be relevant for lookups and counts etc.

The below grab shows the;
1 - multiple values in one cell in red
2 - Added rows in yellow representing the second of the multiple entries with all single entries copied into both rows.

Note, the number of multiple entries possible is infinite

Capture.PNG

Any help is appreciated, I've attached the spreadsheet with before and after shots.

Thanks heaps in advance!!!!

Will

Does the job perfectly, thank you Karedog!!!