I have an Excel file with 297868 rows of data, most with a 10-minute timestamp, and some collected hourly. I want to transform all the data to hourly, which means I need to average the data from the ten minute timestamps into an average over the hour, and convert the whole file to hourly. More specifically, there are two columns- one with the time/date (collected every ten minutes over ten years) and the second column has river height. I need the river height averaged over the hour and converted into an hourly average river height rather than every ten minutes. It would take me a long time but probably is fairly quick for someone more familiar with Excel. I need this done today.
27 freelancers are bidding on average $24 for this job
Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan
Hello, I am Luis and I can assist you today with this task. Please contact me by chat then we could discuss further details about your project. Kind regards, Luis Romero