WM_CONCAT

idvalue1a1c1e2b2d

select ID,wmsys.wm_concat(Val) as Path
  from test
group by ID;

---------------------------------------------------------

idpath1a,c,e2b,d