Hey everyone I have a problem that I am not quite sure how to solve:
I have two data sets that range from the years 2015-2017. Both sets of Data roughly come in the following format: 1/1/2015 00:00 1/1/2015 00:05 etc
My problem is that one of these data sets is not entirely complete (column B) where I am missing days worth of data. This means that when I align the values they do not match up at all which makes any further analysis pointless.
Now my question is, is there a way to sort these values in such a way that if a value from column A does not match column B it looks for teh corresponding value in B, and if it does not exist in B then it just returns an empty string?
Alternatively, would it be possible that I just put my two data sets in two different books and create a third book that "combines" the Y values of these two sets for equal X values?
Here is how the data looks: Data Set 1: X: Time (as shown above) Y: Global irradiation values
Data Set 2 x: Time (same as in Data Set 1 just incomplete) Y: corresponding measured power and voltage values.
1. Put Dataset 1's X and Y into column A and B. 2. Put the X(Time) of dataset 2 (incomplete) in column C. 3. Add new column D. And enter table(A, B, C) in column D's F(x) cell.
It will search times in column C and find the matching rows and put corresponding row's B values into D.
That looks like it could work wonderfully, though I have run into another problem that for some arbitrary reason Origin decides that when I convert the data I have into Dates (format 14/7/2017 HH:mm) it cannot comprehend some of the dates despite them having that exact format.... so while Id like to check this method I first need to solve this little conundrum.
Arranging cells/columns to match values
Posted - 08/09/2017 : 04:11:48 AM
