make an new clean table from different columns

[ovie1]

I have a multi-data sheet where every two columns is a set of data for a particular parameter, the first column is a date and time and the second column in the set is the value.

Sometimes there are missing values marked with *** and sometimes there are missing data and a "jump" in date and time.

I want to create a new table with "clean" and complete data.

In the attached document the tables on the right are data of 3 different values, in the table on the left this is the result of the clean table with the time lines that have full data.

[Qiu · Accepted solution]

@ovie1 

If I understand your intention correctly, the multiple join should do the work.

Can you check the last row of you left table in your PDF? Maybe there is a typo there, since it should be there if not.

[ovie1]

thanks a lot!!!

[Qiu]

@ovie1 
You are welcome and thank you for the accept mark!