for example suppose I have the sample data set as follows:-
email | segment | values |
email1 | segment1 | value1 |
email1 | segment2 | value2 |
email1 | segment3 | value3 |
I want the result as follows:-
email | Seg1 | Seg2 | Seg3 |
email1 | value1 | value2 | value3 |
Post this, we will use value1,value2,value3 in the email delivery as customization fields.
What is the better method to achieve this?