Convert ranges from one to other with formula in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1883667%22%20slang%3D%22en-US%22%3EConvert%20ranges%20from%20one%20to%20other%20with%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1883667%22%20slang%3D%22en-US%22%3EI%20encountered%20a%20problem%20and%20I%20can't%20solve%20it.%20Maybe%20you%20can%20help%20with%20the%20formulas%20to%20solve%20this.%20There%20is%20table%20A%20and%20there%20must%20be%20table%20B.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1883667%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1883740%22%20slang%3D%22en-US%22%3ERe%3A%20Convert%20ranges%20from%20one%20to%20other%20with%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1883740%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F867789%22%20target%3D%22_blank%22%3E%40Artukas8%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20easiest%20way%20is%20with%20Power%20Query%20if%20you%20consider%20it%20as%20an%20option%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-powerquery%22%3E%3CCODE%3Elet%0A%20%20%20%20Source%20%3D%20Excel.CurrentWorkbook()%7B%5BName%3D%22Range%22%5D%7D%5BContent%5D%2C%0A%20%20%20%20%23%22Promoted%20Headers%22%20%3D%20Table.PromoteHeaders(Source%2C%20%5BPromoteAllScalars%3Dtrue%5D)%2C%0A%20%20%20%20%23%22Unpivoted%20Columns%22%20%3D%20Table.UnpivotOtherColumns(%23%22Promoted%20Headers%22%2C%20%7B%7D%2C%20%22Attribute%22%2C%20%22Value%22)%0Ain%0A%20%20%20%20%23%22Unpivoted%20Columns%22%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1885075%22%20slang%3D%22en-US%22%3ERe%3A%20Convert%20ranges%20from%20one%20to%20other%20with%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1885075%22%20slang%3D%22en-US%22%3EI%20don't%20understand%20about%20Power%20Query%2C%20maybe%20you%20can%20explain%20with%20formulas.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1885196%22%20slang%3D%22en-US%22%3ERe%3A%20Convert%20ranges%20from%20one%20to%20other%20with%20formula%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1885196%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F867789%22%20target%3D%22_blank%22%3E%40Artukas8%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFormulas%20are%20also%20depend%20on%20Excel%20version%2C%20on%20which%20one%20you%20are%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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