Q&A about the site for people who build and repair bicycles, people who train cycling, or commute on bicycles
CREATE table #yourtable ([Id] int, [Value] varchar(6), [ColumnName] varchar(13)) ; INSERT INTO #yourtable ([Id], [Value], [ColumnName]) VALUES (1, 'John', 'FirstName'), (2, '2.4', 'Amount'), (3, 'ZH1E4A', 'PostalCode'), (4, 'Fork', 'LastName'), (5, '857685', 'AccountNumber'), (6, 'ADA', 'FirstName'), (7, '2.1', 'Amount'), (8, 'DADA', 'PostalCode'), (9, 'DIDI', 'LastName'), (10, 'DUDU', 'AccountNumber') ; select Firstname, Amount, PostalCode, LastName, AccountNumber from ( select value, columnname from #yourtable ) d pivot ( count(value) for columnname in (Firstname, Amount, PostalCode, LastName, AccountNumber) ) piv;