I am trying to convert rows values to use as columns headers best explained with the following link,

https://data.stackexchange.com/stackoverflow/query/497433

I attached the data screenshot for your reference.

This is the custom query and i have set both the "cols" and "query" as input parameter with Text as data type and expand inline to true.

I kept getting error

DECLARE @cols AS NVARCHAR(MAX), @query AS NVARCHAR(MAX)

select @cols = STUFF((
                        SELECT ',' + QUOTENAME({PersonAttributes}.[ColumnName])
                        FROM {PersonAttributes}
                        GROUP BY {PersonAttributes}.[ColumnName], {PersonAttributes}.[Id]
                        ORDER BY {PersonAttributes}.[Id]
                        FOR XML PATH(''), TYPE
                     ).value('.', 'NVARCHAR(MAX)'),1,1,''
                    )

set @query = N'SELECT ' + @cols + N' FROM
             (
                SELECT {PersonAttributes}.[Value], {PersonAttributes}.[ColumnName]
                FROM {PersonAttributes}
             ) x
             PIVOT
             (
                MAX(value)
                FOR {PersonAttributes}.[ColumnName] IN (' + @cols + N')
             ) p '

exec sp_executesql @query;