Need Help! Data transformation

Hi @v-lili6-msft , Thanks for your help. I have total total 40 columns ( COL1,COL_Value, COL2,COL2_Value.... COL20, COL20_Value) . 

I LIKE your approach. It is simple. Do you think it would be good to create 20 tables from performance and storage point of view?

Can we handle of this manual approach using M query? Like

    SelectColumnFromTable1 = Table.SelectColumns(#"Changed Type",{"COL1","COL1_Value"}),
    SelectColumnFromTable2 = Table.SelectColumns(#"Changed Type_",{"COL2","COL2_Value"}),
    SelectColumnFromTable3 = Table.SelectColumns(#"Changed Type_",{"COL3","COL3_Value"}),
    #"Appended Query" = Table.Combine({SelectColumnFromTable1 , SelectColumnFromTable2, SelectColumnFromTable3 })

And then PIVOT on "Appended Query"

Please advice on this.

Thanks,

Randhir Singh