SQL Server 2019

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

CREATE TABLE t
    (id int, CompanyId int, DealId int, price int)
;
    
INSERT INTO t
    (id, CompanyId, DealId, price)
VALUES
    (1, 1, 1, 100),
    (2, 1, 2, 50),
    (3, 1, 3, 25),
    (4, 2, 1, 1000),
    (5, 2, 2, 2000),
    (6, 2, 3, 2500)
;
6 rows affected

select *
from   t


id
CompanyId
DealId
price


1
1
1
100

2
1
2
50

3
1
3
25

4
2
1
1000

5
2
2
2000

6
2
3
2500


select  CompanyId 
       ,[1] as DealName1
       ,[2] as DealName2
       ,[3] as DealName3
     
from   (select CompanyId, DealId, price from   t) t
pivot  (sum(price) for DealId in([1],[2],[3])) p


CompanyId
DealName1
DealName2
DealName3


1
100
50
25

2
1000
2000
2500