Convert caption row to column

[KyawMyoTun]

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

[wdx223_Daniel · Accepted solution]

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])

[KyawMyoTun]

Hi @wdx223_Daniel ,

  This is working perfectly. Thanks for your help.

Regards,
KMT