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

[ac5a]

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

[Dynamomo · Accepted solution]

@ac5a

this can be done with the Transpose tool.

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

[ac5a]

Brilliant. Thanks!