>>Sure, try:
>>

>>select RowID, [1] as Column1, [2] as Column2 from myTable PIVOT (Min(ID) for ColumnID in ([1],[2])) pvt

>>
>>from the top of my head - not tested.
>
>Min() won't work with uniqueidentiifer :-{

Is it the structure you have?

declare @t table (Id int primary key, ColumnId uniqueidentifier, RowId uniqueidentifier)
insert into @t values (1, NEWID(), NEWID()),(2, NEWID(), NEWID()),(3, NEWID(), NEWID()),(4, NEWID(), NEWID())
select * from @t