Data concatenation

[APC]

I have 2 sets of data. I want to concatenate them. How do i get from image 1 to image 2?

 

[PeteWright]

This works for the example. Make sure to adjust the cell references to your needs.

Book1.xlsx
	A	B	C	D	E	F	G	H
1	19.09.2022 12:00:00	1.00	19.09.2022 12:00:00	125		19.09.2022 12:00:00	1.00	125
2	19.09.2022 12:10:00	2.00	19.09.2022 13:00:00	400		19.09.2022 13:00:00	7.00	400
3	19.09.2022 12:20:00	3.00	19.09.2022 14:00:00	560		19.09.2022 14:00:00	13.00	560
4	19.09.2022 12:30:00	4.00
5	19.09.2022 12:40:00	5.00
6	19.09.2022 12:50:00	6.00
7	19.09.2022 13:00:00	7.00
8	19.09.2022 13:10:00	8.00
9	19.09.2022 13:20:00	9.00
10	19.09.2022 13:30:00	10.00
11	19.09.2022 13:40:00	11.00
12	19.09.2022 13:50:00	12.00
13	19.09.2022 14:00:00	13.00
Sheet4

Cell Formulas
Range	Formula
F1:F3	F1	= C1
G1:G3	G1	= INDEX($B$1:$B$13,MATCH(C1,$A$1:$A$13,0))
H1:H3	H1	=D1