How to copy these cells?
I have the following rows. This is only a small sample. The actual data will go for a year at a time usually.
Date | Time | Open | Close |
04/01/2011 | 8:35 AM | 1020.25 | 1021 |
04/01/2011 | 8:40 AM | 1021.25 | 1022 |
04/01/2011 | 8:45 AM | 1022.25 | 1023 |
04/01/2011 | 8:50 AM | 1023.25 | 1024 |
04/01/2011 | 8:55 AM | 1024.25 | 1025 |
04/01/2011 | 9:00 AM | 1025.25 | 1026 |
04/02/2011 | 8:35 AM | 1027.25 | 1027.5 |
04/02/2011 | 8:40 AM | 1028.25 | 1028.5 |
04/02/2011 | 8:45 AM | 1029.25 | 1029.5 |
04/02/2011 | 8:50 AM | 1030.25 | 1030.5 |
04/02/2011 | 8:55 AM | 1031.25 | 1031.5 |
04/02/2011 | 9:00 AM | 1032.25 | 1032.5 |
04/03/2011 | 8:35 AM | 1031.75 | 1032 |
04/03/2011 | 8:40 AM | 1031.25 | 1031.5 |
04/03/2011 | 8:45 AM | 1030.75 | 1031 |
04/03/2011 | 8:50 AM | 1030.25 | 1030.5 |
04/03/2011 | 8:55 AM | 1029.75 | 1030 |
04/03/2011 | 9:00 AM | 1029.25 | 1029.5 |
I'd like to copy out 8:35/open and 9:00/close into new columns along with date. Time isn't relevant in the new columns. Below I show how this should look.
Date | Time | Open | Close | Date | Open | Close |
04/01/2011 | 8:35 AM | 1020.25 | 1021 | 04/01/2011 | 1020.25 | 1026 |
04/01/2011 | 8:40 AM | 1021.25 | 1022 | 04/02/2011 | 1027.25 | 1032.50 |
04/01/2011 | 8:45 AM | 1022.25 | 1023 | 04/03/2011 | 1031.75 | 1029.25 |
04/01/2011 | 8:50 AM | 1023.25 | 1024 | |||
04/01/2011 | 8:55 AM | 1024.25 | 1025 | |||
04/01/2011 | 9:00 AM | 1025.25 | 1026 | |||
04/02/2011 | 8:35 AM | 1027.25 | 1027.5 | |||
04/02/2011 | 8:40 AM | 1028.25 | 1028.5 | |||
04/02/2011 | 8:45 AM | 1029.25 | 1029.5 | |||
04/02/2011 | 8:50 AM | 1030.25 | 1030.5 | |||
04/02/2011 | 8:55 AM | 1031.25 | 1031.5 | |||
04/02/2011 | 9:00 AM | 1032.25 | 1032.5 | |||
04/03/2011 | 8:35 AM | 1031.75 | 1032 | |||
04/03/2011 | 8:40 AM | 1031.25 | 1031.5 | |||
04/03/2011 | 8:45 AM | 1030.75 | 1031 | |||
04/03/2011 | 8:50 AM | 1030.25 | 1030.5 | |||
04/03/2011 | 8:55 AM | 1029.75 | 1030 | |||
04/03/2011 | 9:00 AM | 1029.25 | 1029.5 |
How can this be accomplished?