merge Multiple row into one row

Copper Contributor

Hello hello

 

I'm new in powerbi and i'm looking some help with a transformation. 

What i'm trying to do with powerquery :

 

tCT9A

first group : call_key ivr_agent cli dnis lang_id next : all other info need to go on one row. the second row with same call_key need to go on new column and the others lin need to go to new columns too.

 

gd7s1

File excel test : https://1drv.ms/x/s!AqE6W5akVSvUh59KfGmUiCSnZH6OVg

Thank you so much for your help

Phil

0 Replies