WITH CTE AS (

SELECT DISTINCT Store, PhoneNr,

ROW_NUMBER() OVER(PARTITION BY Store ORDER BY PhoneNr) AS Items

FROM ##testEnvironment)

SELECT Store,(SELECT PhoneNr FROM CTE AS C WHERE C.Store=P.Store AND C.Items=1 )AS Phone1,

(SELECT PhoneNr FROM CTE AS C WHERE C.Store=P.Store AND C.Items=2 )AS Phone2,

(SELECT PhoneNr FROM CTE AS C WHERE C.Store=P.Store AND C.Items=3 )AS Phone3

FROM CTE AS P