I have design question , may looks straight forward to you..!!
I am getting below duplicate data from Source
I need to convert this source data by removing these 'duplicate' rows but not the values in the Phone* columns
Result should look like below :
Please help. If it can be done without Groovy Script , its highly appreciated ..!!