SQL Server 2017

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

CREATE TABLE dbo.SourceTable (W_ID int NOT NULL,
							Properties_title varchar(3) NOT NULL,
							NumericValue int NULL,
							Property_item_title varchar(100) NULL);
INSERT INTO dbo.SourceTable
VALUES (102859,'AAA',NULL,'Useless'),
	   (102859,'BBB',30000,NULL),
	   (102859,'CCC',NULL,'Repair'),
	   (92527,'AAA',NULL,'Use'),
	   (92527,'BBB',3250,NULL);
5 rows affected

SELECT *
FROM dbo.SourceTable;


W_ID
Properties_title
NumericValue
Property_item_title


102859
AAA
null
Useless

102859
BBB
30000
null

102859
CCC
null
Repair

92527
AAA
null
Use

92527
BBB
3250
null

W_ID	Properties_title	NumericValue	Property_item_title
102859	AAA	null	Useless
102859	BBB	30000	null
102859	CCC	null	Repair
92527	AAA	null	Use
92527	BBB	3250	null