Forum Discussion
Convert ranges from one to other with formula in excel
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.
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.
Formulas are also depend on Excel version, on which one you are?
SergeiBaklan I use Microsoft Office Home and Student 2019