Dealing with merged cells and dates as horizontal titles

[6DiegoDiego9]

I've an Excel range like the following, with merged cells and many dates (3 years) on the horizontal title:

Is there an easy way to transform it for use with Power BI?

i.e. filling the missing Brand and Model values and taking all the dates as as a Date field (unpivot?)

Thanks in advance

[6DiegoDiego9]

Wow thanks a lot!
I'm stunned by how powerful and easy Power Query is!

[Vijay_A_Verma · Accepted solution]

Use this. Sample Excel uploaded here - https://1drv.ms/x/s!Akd5y6ruJhvhuWDGH3OB4nggLBvz?e=wxOqfe 

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Filled Down" = Table.FillDown(Source,{"Brand", "Model"}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Filled Down", {"Color", "Model", "Brand"}, "Date", "Value")
in
    #"Unpivoted Other Columns"