Create new row for each data point but repeat ID number associated/ one to many

Question

Hi,

I am currently trying to do some data prep for salesforce upload.

Input

Salesforce IDContact 1Contact 2Email 1Email 21TomRobsample1@a.com 2Hannah sample2@a.comsample3@.com

Desired Output

Salesforce IDContact1Tom1 Rob1sample1@a.com2Hannah2sample2@a.com2sample3@a.com

Any help would be appreciated.

Thanks

Dynamomo · Accepted Answer

@ac5a

this can be done with the Transpose tool.

Group by the Salesforce ID field and transpose the rest of the fields.