Forum Discussion
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. ...
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])
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])
Hi wdx223_Daniel ,
This is working perfectly. Thanks for your help.
Regards,
KMT