Hi,
I am currently trying to do some data prep for salesforce upload.
Input
Salesforce ID | Contact 1 | Contact 2 | Email 1 | Email 2 |
1 | Tom | Rob | sample1@a.com | |
2 | Hannah | sample2@a.com | sample3@.com |
Desired Output
Salesforce ID | Contact |
1 | Tom |
1 | Rob |
1 | sample1@a.com |
2 | Hannah |
2 | sample2@a.com |
2 | sample3@a.com |
Any help would be appreciated.
Thanks
¡Resuelto! Ir a solución.
this can be done with the Transpose tool.
Group by the Salesforce ID field and transpose the rest of the fields.
Brilliant. Thanks!