Forum Discussion

Artukas8's avatar
Artukas8
Copper Contributor
Nov 13, 2020

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.
Formulas and Functions

4 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 13, 2020

    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"
    • Artukas8's avatar
      Artukas8
      Copper Contributor
      Nov 13, 2020
      I don't understand about Power Query, maybe you can explain with formulas.

Resources