Untitled spreadsheet

	A	B	C	D	E	G	H	I	J	K	M	N
1	Raw data will come as 1 xml file per row in the A column and an ID in column B but each xml file can have up to 12 rows in the C-E columns					Expected result
2	XML	Project ID	Start Day	Lengh	Material	XML	Project ID	Start Day	Lengh	Material	Test ignore	Test Ignore
3	https://filebin.net/4qs9qhmlo1zpv6d7/test-stack.xml?t=dfazzomj	989878	#N/A			https://filebin.net/4qs9qhmlo1zpv6d7/test-stack.xml?t=dfazzomj	989878	1	2.9	Aluminium	https://filebin.net/4qs9qhmlo1zpv6d7/test-stack.xml?t=9mbush3z
4	https://filebin.net/3706qr21r0qoet80/test-stack_-_Copy2.xml?t=dspr087r	989879					989878	2	24	Steel	#N/A	#VALUE!
5							989878	3	2.9	Plastic
6						https://filebin.net/3706qr21r0qoet80/test-stack_-_Copy2.xml?t=dspr087r	989879	4	2.7	Aluminium2
7							989879	5	28	Steel2
8							989879	6	4.9	Plastic2
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100