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
Bookmarks