For simplicity, lets say I have three columns, one column is time every two seconds with data associated that time, and one is time every minute with an associated tidal height. So basically, I want to sort my data so that for every 2 seconds I have an associated tidal height for that minute.
eg:
what I have:
Time Time Tidal Height
(2 sec intervals) (min) (meters)
1:15:00 1:15 1.342
1:15:02 1:16 1.221
1:15:04 1:17 1.115
...
1:15:58 1:43 0.024
1:15:60 1:44 0.012
1:16:00 1:45 0.008
what I want
1:15:00 1:15 1.342
1:15:02 1:15 1.342
1:15:04 1:15 1.342
...
1:15:58 1:15 1.342
1:15:60 1:15 1.342
1:16:00 1:16 1.221
So basically expanding the minute data so there 30 tidal heights expanded out for each minute of data (since it was measured every two seconds?) Anyway... just wondering if you know if excel is smart enough to sort data so that creates either 29 spaces between each of the points in one of the columns... or is able to automatically sort and expand one of the columns.
Bookmarks