Oldest date from column as Column header

I think the installation date should be a column  So you should have reporting date, and installation date as columns, then a values column.  that would allow you to make your table as a pivot table in excel or power bi.  

I was able to recreate your desired table by taking the data unpivoting, filtering on dates first to get the date of each column, then filtering on value to get the value of each column, then merged date&column number from the first tabel with date & column number from the second table.  Load the data then make a pivot table with report date as rows, instalation date as columns and values as values.

I only did 10/10/2022 and 13/10/2022 but you could filter dates from values by contains "/" or does not contain "/" .  There may be a more elegant solution but I ended up with 

Be better if the source data was set up differently tbh