If the data doesn't need to be in seperate columns, you can just concatenate the row values (and this works better if there is no fixed number of values):

Concatenating Row Values in Transact-SQL[/url]