Hi,
I am creating a summary of temperatures logged every hour for three years at several different locations. I am summarizing by the hour (row headings) and location (column headings). The problem is, some locations only logged temperatures every two hours, while some logged every hour. When I add data from locations where the temperature was only logged every two hours, I basically need to leave a blank between every temperature measurement so that the times line-up with the data which was logged every hour. The only way I know to do this is to copy-paste the temperature data into my summary sheet and then manually move it down, leaving blanks for every second row. This would take forever, as I have a lot of data. Is there a way to make excel join data from two workbooks, based on shared values in one column (in this case, hourly times)?
Thanks!
I am creating a summary of temperatures logged every hour for three years at several different locations. I am summarizing by the hour (row headings) and location (column headings). The problem is, some locations only logged temperatures every two hours, while some logged every hour. When I add data from locations where the temperature was only logged every two hours, I basically need to leave a blank between every temperature measurement so that the times line-up with the data which was logged every hour. The only way I know to do this is to copy-paste the temperature data into my summary sheet and then manually move it down, leaving blanks for every second row. This would take forever, as I have a lot of data. Is there a way to make excel join data from two workbooks, based on shared values in one column (in this case, hourly times)?
Thanks!