So I have an excel file with multiple sheets, each containing data for different regions, there are three columns in each sheet, day, hour and temperature. Now each region has temperature recorded on different hours or even different days. I want to create a mastersheet with temperatures of all regions there but arranged in a way that if the temperature wasn't recorded on a specific day or hour, that row will be left blank for the region. I've attached a sample worksheet with two regions data, and an expected output. Any help will be greatly appreciated.
Bookmarks