Arrange column data from multiple sheets based on two columns each sheet has.

[Choochi]

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.

[alansidman]

Load both tables to Power Query/get and transform. Merge the two tables joined on the date and time. Load the joined (merged table) to Excel. Look at the links in my signature for information on how to do this.