Query to normalize table/combine row text
You can create a function that stings the values together using a cursor within the function, but that's about your only option.  You'll need to do row by row processing to make this happen.