Forum Discussion

KyawMyoTun's avatar
KyawMyoTun
Icon for Helper IV rankHelper 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
    Icon for Community Champion rankCommunity 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])