Do you want to do this with formulas or code?
It's tricky with a formula because you want the result in the same
column as the data. Can I suggest using column E? Using MCONCAT
function from the MOREFUNC add-in you can use this formula in E2 copied
down
=IF(D2<"",D2,MCONCAT(D3:INDEX(D3:D$100,MATCH(TRUE ,D3:D$100="",0))))
confirmed with CTRL+SHIFT+ENTER
MOREFUNC add-in is available to download from here
http://www.rhdatasolutions.com/morefunc/
--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile:
http://www.excelforum.com/member.php...o&userid=30486
View this thread:
http://www.excelforum.com/showthread...hreadid=515137