SQL Server 2019

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

SELECT
    '01/03/2021' AS [COB as Date]
  , 'A'          AS [Trader Alias]
  , 'Bros.J'     AS [Trader Code]
  , 'Jon Bros'   AS [Trader Name Primary]
  , -65950       AS [PL Daily]
UNION
SELECT
    '01/03/2021' AS [COB as Date]
  , NULL         AS [Trader Alias]
  , 'Bros.J YTD' AS [Trader Code]
  , 'Jon Bros'   AS [Trader Name Primary]
  , -1237        AS [PL Daily]
UNION
SELECT
    '01/03/2021'  AS [COB as Date]
  , NULL          AS [Trader Alias]
  , 'TRY Accrual' AS [Trader Code]
  , 'Jon Bros'    AS [Trader Name Primary]
  , 0             AS [PL Daily]
UNION
SELECT
    '01/03/2021'  AS [COB as Date]
  , NULL          AS [Trader Alias]
  , 'TRY Funding' AS [Trader Code]
  , 'Jon Bros'    AS [Trader Name Primary]
  , -6210         AS [PL Daily]
UNION
SELECT
    '01/03/2021' AS [COB as Date]
  , NULL         AS [Trader Alias]
  , 'TRY Trader' AS [Trader Code]
  , 'Jon Bros'   AS [Trader Name Primary]
  , 0            AS [PL Daily]
UNION
SELECT
    '02/03/2021' AS [COB as Date]
  , 'B'          AS [Trader Alias]
  , 'Bros.J'     AS [Trader Code]
  , 'Jon Bros'   AS [Trader Name Primary]
  , -28023       AS [PL Daily]
UNION
SELECT
    '02/03/2021' AS [COB as Date]
  , 'C'          AS [Trader Alias]
  , 'Bros.J YTD' AS [Trader Code]
  , 'Jon Bros'   AS [Trader Name Primary]
  , -610         AS [PL Daily]
UNION
SELECT
    '02/03/2021'  AS [COB as Date]
  , NULL          AS [Trader Alias]
  , 'TRY Accrual' AS [Trader Code]
  , 'Jon Bros'    AS [Trader Name Primary]
  , 0             AS [PL Daily]
UNION
SELECT
    '02/03/2021'  AS [COB as Date]
  , NULL          AS [Trader Alias]
  , 'TRY Funding' AS [Trader Code]
  , 'Jon Bros'    AS [Trader Name Primary]
  , 2009          AS [PL Daily];

COB as Date	Trader Alias	Trader Code	Trader Name Primary	PL Daily
01/03/2021	null	Bros.J YTD	Jon Bros	-1237
01/03/2021	null	TRY Accrual	Jon Bros	0
01/03/2021	null	TRY Funding	Jon Bros	-6210
01/03/2021	null	TRY Trader	Jon Bros	0
01/03/2021	A	Bros.J	Jon Bros	-65950
02/03/2021	null	TRY Accrual	Jon Bros	0
02/03/2021	null	TRY Funding	Jon Bros	2009
02/03/2021	B	Bros.J	Jon Bros	-28023
02/03/2021	C	Bros.J YTD	Jon Bros	-610