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.
Solved! Go to Solution.
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.
thanks a lot!!!
@ovie1
You are welcome and thank you for the accept mark!