I have a data extension that has duplicate email addresses with each duplicate having a different rank associated with it. I need to dedupe the email addresses but keep the different ranks in added fields.
So I currently have:
Email_address, Rank Email1, rank1 Email1, rank2 Email1, rank3 Email2, rank1 Email2, rank2
And what I need is:
Email_address, Rank1, Rank2, Rank3 Email1, rank1, rank2, rank3 Email2, rank1, rank2
I've tried using the CASE function in an SOQL query but it's not returning the outcome I was looking for. Is there a way of getting the data how I need it using querys?