Nov 13 2020 12:55 AM
Nov 13 2020 01:14 AM
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"
Nov 13 2020 07:57 AM
Nov 13 2020 08:18 AM
Formulas are also depend on Excel version, on which one you are?
Nov 14 2020 10:54 AM
@Sergei Baklan I use Microsoft Office Home and Student 2019