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.