You need to specify the actual values from the column you are pivoting, not just [0],[1]…:

SELECT * FROM src PIVOT ( MIN(PictId) FOR SeoFileName in ([strawberry],[strawberry_1],[pinapples],[banana],[banana_1],[orange] ) ) As Pvt GO

xxxxxxxxxx

 

SELECT * FROM src

PIVOT (

  MIN(PictId)

  FOR SeoFileName in ([strawberry],[strawberry_1],[pinapples],[banana],[banana_1],[orange]

  )

) As Pvt

GO

Name	Price	strawberry	strawberry_1	pinapples	banana	banana_1	orange
Banana	10	null	null	null	4	5	null
Orange	11	null	null	null	null	null	6
Pineapples	10	null	null	3	null	null	null
Strawberries	11	1	2	null	null	null	null

I wonder if you really just want a list of seofilename like so:

SELECT name, STRING_AGG(seofilename,',') seofilenames FROM src GROUP BY name; GO

xxxxxxxxxx

 

SELECT name, STRING_AGG(seofilename,',') seofilenames

FROM src

GROUP BY name;

GO

name	seofilenames
Banana	banana,banana_1
Orange	orange
Pineapples	pinapples
Strawberries	strawberry,strawberry_1

db<>fiddle here