VBA Transpsoe data

[ExcelNoob95]

Hi, I am new to VBA, and for my work I am suppose to clean my data to be in Power BI format.
As shown in the workbook, the raw data is above and the final cleaned(transposed) data is below. I want to create a macro so that the raw data can be transposed into the clean data. In raw data the date is odd, only shows the day of the month(can be seen in the workbook, so would need a macro to correct the date. Also in the clean data there is an added column for location, this data for location is fixed for this excel, i have other excel with the same format of raw data but they are for different location, so would need a macro to add the location column and key in the location name for that excel, so in power bi, can combine all excel files and their data can be differentiated by location even though they have same properties. This raw data cannot use direct transposing if you see the raw data I am handling and my desired clean data, that is why it requires VBA. The sample workbook attached is a simplified version of the actual one I'm working on, where there are more 50+ properties and dates reaching August 2020. So the VBA probably will require a loop. Would be so grateful to if anyone can create a macro to turn the raw data into the clean data. I tried doing myself but so far I haven't found an online video/tutorial on how to transpose data for my case.