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-CU1) (KB4527376) - 15.0.4003.23 (X64) 
	Dec  6 2019 14:53:33 
	Copyright (C) 2019 Microsoft Corporation
	Express Edition (64-bit) on Windows Server 2019 Standard 10.0 <X64> (Build 17763: ) (Hypervisor)



CREATE TABLE test (
id INT,
attrName VARCHAR(255),
attrValue VARCHAR(255),
);
INSERT INTO test VALUES 
(1, 'Website', 'wwww.abc.com'),
(2, 'Faebook', 'wwww.facebok.com'),
(1, 'Website', 'wwww.abc.com'),
(2, 'Faebook', 'wwww.facebok.com'),
(1, 'Instagram', 'wwww.instagram.com/123');
5 rows affected

SELECT t.id, STRING_AGG(CONCAT(t.attrName, ': ', t.attrValue, ';'), ' ') as Weblinks
FROM test t
GROUP BY t.id
ORDER BY t.id;


id
Weblinks


1
Website: wwww.abc.com; Website: wwww.abc.com; Instagram: wwww.instagram.com/123;

2
Faebook: wwww.facebok.com; Faebook: wwww.facebok.com;

id	Weblinks
1	Website: wwww.abc.com; Website: wwww.abc.com; Instagram: wwww.instagram.com/123;
2	Faebook: wwww.facebok.com; Faebook: wwww.facebok.com;