SQL Server 2014

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

CREATE TABLE IQC_Tensile_TF(
batch BIGINT, 
node_number INT, 
characteristic INT, 
inspection_unit_number INT, 
measured_value DECIMAL(5,2)
)

INSERT INTO IQC_Tensile_TF VALUES

(5003054535, 2, 10 ,1 , 9.5 ),
(5003054535, 2, 10 ,2 , 9.7 ),
(5003054535, 2, 10 ,3 , 9.4 ),
(5003054535, 2, 10 ,4 , 9.5 ),
(5003054535, 2, 10 ,5 , 9.7 ),
(5003054535, 2, 10 ,6 , 9.4 ),
(5003054535, 2, 10 ,7 , 9.5 ),
(5003054535, 2, 10 ,8 , 9.7 ),
(5003054535, 2, 10 ,9 , 9.4 ),
(5003054535, 2, 10 ,10, 9.5 ),
(5003054535, 2, 10 ,11, 9.7 ),
(5003054535, 2, 10 ,12, 9.4 ),
(5003054535, 2, 10 ,13, 9.5 ),
(5003054535, 2, 10 ,14, 9.7 ),
(5003054535, 2, 10 ,15, 9.4 ),
(5003054535, 2, 10 ,16, 9.5 ),
(5003054535, 2, 10 ,17, 9.7 ),
(5003054535, 2, 10 ,18, 9.4 ),
(5003054535, 2, 10 ,19, 9.5 ),
(5003054535, 2, 10 ,20, 9.7 ),
(5003054535, 2, 10 ,21, 9.4 ),
(5003054535, 2, 10 ,22, 9.5 ),
(5003054535, 2, 10 ,23, 9.7 ),
(5003054535, 2, 10 ,24, 9.4 ),
(5003054535, 2, 10 ,25, 9.5 ),
(5003054535, 2, 10 ,26, 9.7 ),
(5003054535, 2, 10 ,27, 9.4 ),
(5003054535, 2, 10 ,28, 9.5 ),
(5003054535, 2, 10 ,29, 9.7 ),
(5003054535, 2, 20 ,1, 9.46 ),
(5003054535, 2, 20 ,2, 9.5  ),
(5003054535, 2, 20 ,3, 9.74 ),
(5003054535, 2, 20 ,4, 9.46 ),
(5003054535, 2, 20 ,5, 9.5  ),
(5003054535, 2, 20 ,6, 9.74 ),
(5003054535, 2, 20 ,7, 9.46 )

36 rows affected

batch	node_number	characteristic	TestResults1	TestResults2	TestResults3	TestResults4	TestResults5	TestResults6	TestResults7	TestResults8	TestResults9	TestResults10	TestResults11	TestResults12	TestResults13	TestResults14	TestResults15	TestResults16	TestResults17	TestResults18	TestResults19	TestResults20	TestResults21	TestResults22	TestResults23	TestResults24	TestResults25	TestResults26	TestResults27	TestResults28	TestResults29
5003054535	2	10	9.50	9.70	9.40	9.50	9.70	9.40	9.50	9.70	9.40	9.50	9.70	9.40	9.50	9.70	9.40	9.50	9.70	9.40	9.50	9.70	9.40	9.50	9.70	9.40	9.50	9.70	9.40	9.50	9.70
5003054535	2	20	9.46	9.50	9.74	9.46	9.50	9.74	9.46	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null	null