SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE t (
  `customer_name` VARCHAR(6),
  `transaction_date` VARCHAR(19)
);

INSERT INTO t
  (`customer_name`, `transaction_date`)
VALUES
  ('Jim', '1/1/22'),
  ('Jim', '3/1/22'),
  ('Pam', '1/2/22'),
  ('Dwight', '12/23/21'),
  ('Pam', '4/1/20'),
  ('Jim', '3/3/22'),
  ('Dwight', '1/1/22'),
  ('Pam', '8/1/22'),
  ('Dwight', '10/1/22');
Msg 102 Level 15 State 1 Line 2
Incorrect syntax near '`'.
Msg 102 Level 15 State 1 Line 7
Incorrect syntax near '`'.

CREATE TABLE t
    (class varchar(1), parameter varchar(4), value varchar(4))
;
    
INSERT INTO t
    (class, parameter, value)
VALUES
    ('A', 'name', 'John'),
    ('A', 'city', 'NY'),
    ('A', 'year', '2022'),
    ('B', 'name', 'ANNA'),
    ('B', 'city', 'NM'),
    ('B', 'year', '2021')
;
6 rows affected

select *
from   t
pivot (max(value) for parameter in([name], [city], [year]))  pvt


class
name
city
year


A
John
NY
2022

B
ANNA
NM
2021