Q&A for physical fitness professionals, athletes, trainers, and those providing health-related needs
CREATE table #yourtable ([Id] int, [Value] varchar(6), [ColumnName] varchar(13), [test] varchar(13)) ; INSERT INTO #yourtable ([Id], [Value], [ColumnName], [test]) VALUES (1, 'John', 'FirstName', 'test010'), (2, '2.4', 'Amount', 'test011'), (3, 'ZH1E4A', 'PostalCode', 'test010'), (4, 'Fork', 'LastName', 'test010'), (5, '857685', 'AccountNumber', 'test010') ; select Firstname, Amount, PostalCode, LastName, AccountNumber, test from ( select value, columnname, test from #yourtable ) d pivot ( max(value) for columnname in (Firstname, Amount, PostalCode, LastName, AccountNumber) ) piv;