SQL Server 2019

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


(No column name)


Microsoft SQL Server 2019 (RTM-CU6) (KB4563110) - 15.0.4053.23 (X64) 
 Jul 25 2020 11:26:55 
 Copyright (C) 2019 Microsoft Corporation
 Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)



CREATE TABLE tbl (
   [Date] DATE,
   Person CHAR(1),
   Number1 INTEGER,
   Number2 INTEGER
   );
INSERT INTO tbl VALUES
('2015-01-03',  'A',         4,          6),
('2015-01-04',  'A',         2,          5),
('2015-01-05',  'A',         3,          1),
('2015-01-03',  'B',         5,          3),
('2015-01-04',  'B',         6,          4),
('2015-01-05',  'B',         7,          6);
6 rows affected

-- my Code
SELECT
    a.Date,
    a.Number1 as "A1",
    b.Number1 as "B1",
    a.Number2 as "A2",
    b.Number2 as "B2"
FROM tbl a
INNER JOIN tbl b on b.Date=a.Date AND b.Person='B'
WHERE a.Person='A'


Date
A1
B1
A2
B2


2015-01-03
4
5
6
3

2015-01-04
2
6
5
4

2015-01-05
3
7
1
6