Forum Discussion

KyawMyoTun's avatar
KyawMyoTun
Helper IV
3 years ago
Solved

Convert caption row to column

Dear Experts,
I have a table as below.
 

I would like to transform above table to be usable in power query as below.

Please help me to transfrom the table in power query. Thank you.

Regards,
Kyaw Myo Tun

Need Help
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    just for the sample data

    NewStep=Table.FromPartitions("Department",Table.Group(PreviousStepName,"Name",{"n",each {[ID]{0},Table.Skip(_)}},0,(x,y)=>Byte.From(y=null or y=""))[n])

2 Replies

  • wdx223_Daniel's avatar
    wdx223_Daniel
    Community Champion
    3 years ago

    just for the sample data

    NewStep=Table.FromPartitions("Department",Table.Group(PreviousStepName,"Name",{"n",each {[ID]{0},Table.Skip(_)}},0,(x,y)=>Byte.From(y=null or y=""))[n])