Transform multiple row entries for same ID number into columns

gparks

I have a dataset that I am working on that for every ID number, there are multiple fields in the "Location" column, which creates repeats of the ID number in the dataset. I would rather have columns titled "Location_1","Location_2" etc so that there are all unique ID numbers in the rows. Any ideas on how to do this? 

Capture.PNG

atcodedog05

Hi @gparks 

Here is a workflow for the task.

Input:

Output:

Workflow:

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

location.yxmd