With some assistance I managed to put together the necessary formulas to translate a dataset that needed each row splitting into multiple rows.
The original thread can be found here;

http://www.excelforum.com/excel-form...s-failing.html

This approach is fairly resource intensive and my Laptop fails to generate results after a certain point and with the full data set it just fails, so I was advised to look at VBA, however its an area that I'm pretty weak on unfortunately.

Can anybody point me in the right direction ?

ROW TO MULTI ROW.xlsx

Thanks,

Nic