I need to merge multiple rows into one row in azure data factory, per example I have the following file
At the end I need to have
PolicyId Driver_name1 Driver name2
0001 Adam Lucy
I don't see any option on the data flow activity to do it, please can you help me??