How to recursively append cells?

I have an Excel sheet that looks like this:

ID        PARENTID        VALUE                  RESOLVED VALUE (how to generate this?)
 =======================================================================================
 0         0               /root                  /root
 1         0               /one                   /root/one
 2         1               /two                   /root/two
 3         1               /three                 /root/three
 4         3               /child-one-of-three    /root/three/child-one-of-three
 5         3               /child-two-of-three    /root/three/child-two-of-three
 

Each row has an ID and a PARENTID. I want to generate the content of the last column, RESOLVED VALUE by resursively append the VALUE of each row.

How can I do this in Excel?

---