combining data in excel sheet in multiple rows into a single row

One Star

combining data in excel sheet in multiple rows into a single row

Hello all,

I have to build a job where the data is in the excel sheet as follows

 

id

vaultstatusaction

OQ3000000000Q42

Pending FDD Review

OQ3000000000Q43

Pending FDD Review

OQ3000000000Q44

Pending FDD Review

OQ3000000000Q45

Pending FDD Review

OQ3000000000O53

api/v18.1/vobjects/disclosure__c/OQ3000000000O53/actions/Objectlifecyclestateuseraction.disclosure__c.change_state_to_accepted_without_fdd_rev__c

OQ3000000000O54

api/v18.1/vobjects/disclosure__c/OQ3000000000O54/actions/Objectlifecyclestateuseraction.disclosure__c.change_state_to_accepted_without_fdd_rev__c

OQ3000000000O55

api/v18.1/vobjects/disclosure__c/OQ3000000000O55/actions/Objectlifecyclestateuseraction.disclosure__c.change_state_to_accepted_without_fdd_rev__c

 

the output needed is

 

 

 

url

idlist

api/v18.1/vobjects/disclosure__c/actions/Objectlifecyclestateuseraction.disclosure__c.change_state_to_accepted_without_fdd_rev__c "

 

"id = OQ3000000000Q42,OQ3000000000Q43,OQ3000000000Q45"

so I have to get 100 ids in a single row in the second column separated by a comma. Can anyone help me with this?

 

Thirteen Stars

Re: combining data in excel sheet in multiple rows into a single row

@Chaithra_kb,are you looking for the below one?

Untitled.pngUntitled.pngUntitled.pngUntitled.png

Manohar B