LIke this

IF OBJECT_ID('TempDB..#Temp') IS NOT NULL

DROP TABLE #Temp;

GO

;

CREATE TABLE #Temp

(

Store INT

,PhoneNr VARCHAR(20)

)

;

INSERT INTO #Temp (Store,PhoneNr)

SELECT 4711 , '49911-1111111'

UNION ALL SELECT 4711 , '49911-1111112'

UNION ALL SELECT 4711 , '49911-1111113'

;

; WITH CTE AS

(

SELECT T.Store , T.PhoneNr

, RN = ROW_NUMBER() OVER(PARTITION BY T.Store ORDER BY T.PhoneNr)

FROM #Temp T

)

SELECT Store

, [1] AS Phone1

, [2] AS Phone2

, [3] AS Phone3

FROM CTE

PIVOT ( MAX(PhoneNr) FOR RN IN ([1],[2],[3])) Pivot_Handle