How to move/sort data from two columns to match data in another column?

Question

Hello there, first time asking a question so be gentle. I have data from three different meters, each meter gives a timestamp in one column and the data in a second column, so six columns total in excel. However one meter records data every 5 minutes, vs 15 minutes for the other meters. I need to make a plot with the meter data combined. How can I sort the data so the dates and data values match up in a row? I dont know how I can upload the file but I can maybe do a screenshot. The data in columns J and K is an example of what I am trying to achieve if that helps. There's far more data from the Lumbago meter than the other two meters also. So basically I want the data from each meter on day X, time Y to match up so they can be easily added together.

Answer 1

In K3:

=XLOOKUP(J3, $A$3:$A$10000, $B$3:$B$10000, 0)+XLOOKUP(J3, $D$3:$D$10000, $E$3:$E$10000, 0)+XLOOKUP(J3, $G$3:$G$10000, $H$3:$H$10000, 0)

Fill down.