Combining Excel Data
I want to combine 2 sets of Excel data for the same time period and one was collected every second and the second one every minute. How can I combine/merge the second set of data into the first fir...
Forum Discussion
Thanks for the ideas they are great - I just need some time to try them and get back to you guys and apologize for the delay.
The "every second" data is solar controller data collected every 5 seconds and in UTC time format. I use a formula to add a am/pm time column that humans can understand. Hopefully I could convert this column to values and sort the two sets of data. The second set of data is sun elevations from the USNO lab and it has a standard am/pm time scale. I have graphs of both data that could be combined. Just thought I'd let you know about the application.
It's been awhile since I've used Excel macros but that is a challenge going forward and I did ask and want those kinds of options.
Thanks to both of you for giving me options.
The "every second" data is solar controller data collected every 5 seconds and in UTC time format. I use a formula to add a am/pm time column that humans can understand. Hopefully I could convert this column to values and sort the two sets of data. The second set of data is sun elevations from the USNO lab and it has a standard am/pm time scale. I have graphs of both data that could be combined. Just thought I'd let you know about the application.
It's been awhile since I've used Excel macros but that is a challenge going forward and I did ask and want those kinds of options.
Thanks to both of you for giving me options.
