Avatar

Level 1

Hi All,

Can you please help me in finding a way to transpose the data from different columns into a single for a customer. I am using adobe campaign V7 

 

PartyIdMonthMoney_arrears
123Jan20
123Feb27
123Mar45

 

I am looking for transposing the data into something like

 

PartyIdMonth_JanMonth_FebMonth_March
123202745

 

Many Thanks

Chinni