Hello,
I am trying to add up data from multiple excel-files to make a new one with all the data in one file. The data consists of observation data taken on time intervals. In one file data is taken every 30 minutes and in another file data is taken every 60 minutes. When I group the data from both files the dates don’t match, because of different sampling rates.
So for example I have the following kind of data in excel-file 1:
1/1/2006 15:00 100
1/1/2006 15:30 97
1/1/2006 16:00 105
1/1/2006 16:30 101
1/1/2006 17:00 97
.
.
etc
and in excel-file 2 I have:
1/1/2006 15:00 3
1/1/2006 16:00 5
1/1/2006 17:00 4
.
.
etc
Now if I add up these files I get the following:
1/1/2006 15:00 100 3
1/1/2006 15:30 97 5
1/1/2006 16:00 105 4
1/1/2006 16:30 101
1/1/2006 17:00 97
But as you can see this is wrong, because of the different sampling rates
What I would want is the following:
1/1/2006 15:00 100 3
1/1/2006 15:30 97
1/1/2006 16:00 105 5
1/1/2006 16:30 101
1/1/2006 17:00 97 4
So what I need to do is add extra cells between the values in the column from excel-file 2. I hope I was clear enough =) How can I do this in Libreoffice Calc, because inserting cells manually is not an option because I have more than 10 000 rows of data =)
all help appreciated! =)