If you have limited number of values in column1 that you want to transpose, then it is possible using CASE statement.

But it is not very clear from the sample you posted, what you want in result. You have two rows in sample, do you want everything in one row?