SQL Server 2019

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

CREATE TABLE machines_in_operation (
source text, object text, serial_number text, redirect text, model text);
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf1','Cont1','abc1235','Client1', 'S10');
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf2','Cont2','abc12356','Client2', 'S10');
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf3','Cont2','abc124','Client3', 'L10');
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf1','Cont2','abc12378','Client1', 'L10');
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf2','Cont2','abc12390','Client3', 'L10');
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf3','Cont2','abc12312','Client1', 'L10');
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf2','Cont2','abc12345','Client2', 'S10');
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf1','Cont4','abc17313','Client6', 'L10');
INSERT INTO machines_in_operation (source, object, serial_number, redirect, model)VALUES('Inf2','Cont4','abc18313','Client6', 'L10');

SELECT * FROM machines_in_operation;

source	object	serial_number	redirect	model
Inf1	Cont1	abc1235	Client1	S10
Inf2	Cont2	abc12356	Client2	S10
Inf3	Cont2	abc124	Client3	L10
Inf1	Cont2	abc12378	Client1	L10
Inf2	Cont2	abc12390	Client3	L10
Inf3	Cont2	abc12312	Client1	L10
Inf2	Cont2	abc12345	Client2	S10
Inf1	Cont4	abc17313	Client6	L10
Inf2	Cont4	abc18313	Client6	L10

source	object	redirect	model	quantity
Inf1	Cont1	Client1	S10	1
Inf1	Cont2	Client1	L10	2
Inf2	Cont2	Client2	S10	2
Inf1	Cont1	Client1	S10	1
Inf1	Cont4	Client6	L10	1
Inf2	Cont4	Client6	L10	1