Here is an approach without using Pivot
DECLARE @T TABLE (data VARCHAR(50), rowno INT, colno INT)
INSERT INTO @T
SELECT 'abc', 1, 1 UNION ALL
SELECT '12', 1, 2 UNION ALL
SELECT 'xyz', 2, 1 UNION ALL
SELECT '89', 2, 2
SELECT Col1, Col2 FROM
(
SELECT Data AS Col1, RowNo, ColNo FROM @T
WHERE ColNo = 1
) A
INNER JOIN
(
SELECT Data AS Col2, RowNo, ColNo FROM @T
WHERE ColNo = 2
) B ON A.RowNo = B.RowNo