Spreadsheet: 272855d1382532770-how-do-i-align-two-sets-of-data-that-have-different-time-stamps-temp-data-example
Sheet: Sheet1

LOCATION 1 |  |  |  |  |  | LOCATION 2 |  |  |  |  |  | This is what I'm trying to accomplish via formula vs. copy paste…
interval | date | time |  | temp |  | interval | date | time |  | temp
1 | 2013-09-25 00:00:00 | 10:00:00 | AM | 17.249 |  | 1 | 2013-09-25 00:00:00 | 10:00:00 | AM | 18.152 |  | 1 | 2013-09-25 00:00:00 | 10:00:00 | AM | 17.249
2 | 2013-09-25 00:00:00 | 10:10:00 | AM | 15.175 |  |  | 2013-09-25 00:00:00 | 11:00:00 | AM | 15.629 |  | 7 | 2013-09-25 00:00:00 | 11:00:00 | AM | 15.461
3 | 2013-09-25 00:00:00 | 10:20:00 | AM | 15.175 |  |  | 2013-09-25 00:00:00 | 12:00:00 | PM | 16.344 |  | etc
4 | 2013-09-25 00:00:00 | 10:30:00 | AM | 15.247 |  |  | 2013-09-25 00:00:00 | 01:00:00 | PM | 17.153 |  | etc
5 | 2013-09-25 00:00:00 | 10:40:00 | AM | 15.294 |  |  | 2013-09-25 00:00:00 | 02:00:00 | PM | 18.01 |  | etc
6 | 2013-09-25 00:00:00 | 10:50:00 | AM | 15.366 |  |  | 2013-09-25 00:00:00 | 03:00:00 | PM | 18.866
7 | 2013-09-25 00:00:00 | 11:00:00 | AM | 15.461 |  |  | 2013-09-25 00:00:00 | 04:00:00 | PM | 19.341
8 | 2013-09-25 00:00:00 | 11:10:00 | AM | 15.557 |  |  | 2013-09-25 00:00:00 | 05:00:00 | PM | 19.698
9 | 2013-09-25 00:00:00 | 11:20:00 | AM | 15.629 |  |  | 2013-09-25 00:00:00 | 06:00:00 | PM | 19.508
10 | 2013-09-25 00:00:00 | 11:30:00 | AM | 15.748 |  |  | 2013-09-25 00:00:00 | 07:00:00 | PM | 19.151
11 | 2013-09-25 00:00:00 | 11:40:00 | AM | 15.843 |  |  | 2013-09-25 00:00:00 | 08:00:00 | PM | 18.699
12 | 2013-09-25 00:00:00 | 11:50:00 | AM | 15.963 |  |  | 2013-09-25 00:00:00 | 09:00:00 | PM | 18.247
13 | 2013-09-25 00:00:00 | 12:00:00 | PM | 16.082 |  |  | 2013-09-25 00:00:00 | 10:00:00 | PM | 17.843
14 | 2013-09-25 00:00:00 | 12:10:00 | PM | 16.177 |  |  | 2013-09-25 00:00:00 | 11:00:00 | PM | 17.415
15 | 2013-09-25 00:00:00 | 12:20:00 | PM | 16.32 |  |  | 2013-09-26 00:00:00 | 12:00:00 | AM | 17.034
16 | 2013-09-25 00:00:00 | 12:30:00 | PM | 16.415 |  |  | 2013-09-26 00:00:00 | 01:00:00 | AM | 16.63
17 | 2013-09-25 00:00:00 | 12:40:00 | PM | 16.582 |  |  | 2013-09-26 00:00:00 | 02:00:00 | AM | 16.296
18 | 2013-09-25 00:00:00 | 12:50:00 | PM | 16.677
19 | 2013-09-25 00:00:00 | 01:00:00 | PM | 16.82
20 | 2013-09-25 00:00:00 | 01:10:00 | PM | 16.987
21 | 2013-09-25 00:00:00 | 01:20:00 | PM | 17.106
22 | 2013-09-25 00:00:00 | 01:30:00 | PM | 17.225
23 | 2013-09-25 00:00:00 | 01:40:00 | PM | 17.391
24 | 2013-09-25 00:00:00 | 01:50:00 | PM | 17.51
25 | 2013-09-25 00:00:00 | 02:00:00 | PM | 17.629
26 | 2013-09-25 00:00:00 | 02:10:00 | PM | 17.772
27 | 2013-09-25 00:00:00 | 02:20:00 | PM | 17.891
28 | 2013-09-25 00:00:00 | 02:30:00 | PM | 18.033
29 | 2013-09-25 00:00:00 | 02:40:00 | PM | 18.152
30 | 2013-09-25 00:00:00 | 02:50:00 | PM | 18.271
31 | 2013-09-25 00:00:00 | 03:00:00 | PM | 18.39
32 | 2013-09-25 00:00:00 | 03:10:00 | PM | 18.485
33 | 2013-09-25 00:00:00 | 03:20:00 | PM | 18.58
34 | 2013-09-25 00:00:00 | 03:30:00 | PM | 18.699
35 | 2013-09-25 00:00:00 | 03:40:00 | PM | 18.771
36 | 2013-09-25 00:00:00 | 03:50:00 | PM | 18.866
37 | 2013-09-25 00:00:00 | 04:00:00 | PM | 18.961
38 | 2013-09-25 00:00:00 | 04:10:00 | PM | 19.008
39 | 2013-09-25 00:00:00 | 04:20:00 | PM | 19.056
40 | 2013-09-25 00:00:00 | 04:30:00 | PM | 19.103
41 | 2013-09-25 00:00:00 | 04:40:00 | PM | 19.151
42 | 2013-09-25 00:00:00 | 04:50:00 | PM | 19.151
43 | 2013-09-25 00:00:00 | 05:00:00 | PM | 19.199
44 | 2013-09-25 00:00:00 | 05:10:00 | PM | 19.222
45 | 2013-09-25 00:00:00 | 05:20:00 | PM | 19.246
46 | 2013-09-25 00:00:00 | 05:30:00 | PM | 19.246
47 | 2013-09-25 00:00:00 | 05:40:00 | PM | 19.27
48 | 2013-09-25 00:00:00 | 05:50:00 | PM | 19.246
49 | 2013-09-25 00:00:00 | 06:00:00 | PM | 19.222
50 | 2013-09-25 00:00:00 | 06:10:00 | PM | 19.175
51 | 2013-09-25 00:00:00 | 06:20:00 | PM | 19.127
52 | 2013-09-25 00:00:00 | 06:30:00 | PM | 19.056
53 | 2013-09-25 00:00:00 | 06:40:00 | PM | 19.008
54 | 2013-09-25 00:00:00 | 06:50:00 | PM | 18.961
55 | 2013-09-25 00:00:00 | 07:00:00 | PM | 18.889
56 | 2013-09-25 00:00:00 | 07:10:00 | PM | 18.842
57 | 2013-09-25 00:00:00 | 07:20:00 | PM | 18.771
58 | 2013-09-25 00:00:00 | 07:30:00 | PM | 18.699
59 | 2013-09-25 00:00:00 | 07:40:00 | PM | 18.652
60 | 2013-09-25 00:00:00 | 07:50:00 | PM | 18.58
61 | 2013-09-25 00:00:00 | 08:00:00 | PM | 18.509
62 | 2013-09-25 00:00:00 | 08:10:00 | PM | 18.438
63 | 2013-09-25 00:00:00 | 08:20:00 | PM | 18.366
64 | 2013-09-25 00:00:00 | 08:30:00 | PM | 18.295
65 | 2013-09-25 00:00:00 | 08:40:00 | PM | 18.224
66 | 2013-09-25 00:00:00 | 08:50:00 | PM | 18.152
67 | 2013-09-25 00:00:00 | 09:00:00 | PM | 18.057
68 | 2013-09-25 00:00:00 | 09:10:00 | PM | 18.01
69 | 2013-09-25 00:00:00 | 09:20:00 | PM | 17.938
70 | 2013-09-25 00:00:00 | 09:30:00 | PM | 17.867
71 | 2013-09-25 00:00:00 | 09:40:00 | PM | 17.772
72 | 2013-09-25 00:00:00 | 09:50:00 | PM | 17.724
73 | 2013-09-25 00:00:00 | 10:00:00 | PM | 17.653
74 | 2013-09-25 00:00:00 | 10:10:00 | PM | 17.558
75 | 2013-09-25 00:00:00 | 10:20:00 | PM | 17.51
76 | 2013-09-25 00:00:00 | 10:30:00 | PM | 17.463
77 | 2013-09-25 00:00:00 | 10:40:00 | PM | 17.391
78 | 2013-09-25 00:00:00 | 10:50:00 | PM | 17.32
79 | 2013-09-25 00:00:00 | 11:00:00 | PM | 17.249
80 | 2013-09-25 00:00:00 | 11:10:00 | PM | 17.177
81 | 2013-09-25 00:00:00 | 11:20:00 | PM | 17.13
82 | 2013-09-25 00:00:00 | 11:30:00 | PM | 17.058
83 | 2013-09-25 00:00:00 | 11:40:00 | PM | 16.987
84 | 2013-09-25 00:00:00 | 11:50:00 | PM | 16.915
85 | 2013-09-26 00:00:00 | 12:00:00 | AM | 16.868
86 | 2013-09-26 00:00:00 | 12:10:00 | AM | 16.796
87 | 2013-09-26 00:00:00 | 12:20:00 | AM | 16.725
88 | 2013-09-26 00:00:00 | 12:30:00 | AM | 16.677
89 | 2013-09-26 00:00:00 | 12:40:00 | AM | 16.606
90 | 2013-09-26 00:00:00 | 12:50:00 | AM | 16.534
91 | 2013-09-26 00:00:00 | 01:00:00 | AM | 16.487
92 | 2013-09-26 00:00:00 | 01:10:00 | AM | 16.415
93 | 2013-09-26 00:00:00 | 01:20:00 | AM | 16.368
94 | 2013-09-26 00:00:00 | 01:30:00 | AM | 16.32
95 | 2013-09-26 00:00:00 | 01:40:00 | AM | 16.249
96 | 2013-09-26 00:00:00 | 01:50:00 | AM | 16.201
97 | 2013-09-26 00:00:00 | 02:00:00 | AM | 16.129
98 | 2013-09-26 00:00:00 | 02:10:00 | AM | 16.082
99 | 2013-09-26 00:00:00 | 02:20:00 | AM | 16.034