How to combine column 1 and column 2 such that all the elements in column 2 move below column 1?

Anonymous 

Create a function from the code above (named  "function_")

(inputT_ as table)=> 
let
    colNames_ = Table.ColumnNames(inputT_),
    colNum_ = Table.ColumnCount(inputT_),
    auxList_ = List.Numbers(0,colNum_/2),
    auxList2_ = List.Transform(auxList_, each Table.RenameColumns(Table.SelectColumns(inputT_,List.Range(colNames_, _*2,2)),{{colNames_{_*2}, "Value"}, {colNames_{_*2+1}, "Variable"}})), 
    TFinal_ = Table.Combine(auxList2_)
in
    TFinal_

 Then you can apply it on the query you showed above:

let
 Source = Web.Page(Web.Contents("https://finviz.com/quote.ashx?t=FB&ty=c&p=d&b=1")),
 res_ = function_ (Source{0}[Data])
in
 res_

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

Anonymous 

See it all at work in the attached file

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

Hello Anonymous 

did any of the answer suit your requirements? If yes, please mark them as solution please

BR

Jimmy