Convert ranges from one to other with formula in excel

Copper Contributor
I encountered a problem and I can't solve it. Maybe you can help with the formulas to solve this. There is table A and there must be table B.
4 Replies

@Artukas8 

The easiest way is with Power Query if you consider it as an option

let
    Source = Excel.CurrentWorkbook(){[Name="Range"]}[Content],
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Promoted Headers", {}, "Attribute", "Value")
in
    #"Unpivoted Columns"
I don't understand about Power Query, maybe you can explain with formulas.

@Artukas8 

Formulas are also depend on Excel version, on which one you are?

@Sergei Baklan I use Microsoft Office Home and Student 2019