Splitting data into columns by ID#

[peyton-louden]

Hi all, 

I have a dataset that needs to be split based on ID. The data is grouped by an ID# that I would like split the ID groups then put them on the same row. 

Below is a screenshot of how data is received:

Below is the desired result:

I've also attached the sample data for reference. 

I'm thinking it could be solved with some Cross-tab or Transpose tools but I don't have much experience with those tools and have no idea where to start. Any help or guidance would be appreciated.

Thanks!

[Luke_C · Accepted solution]

Hi @peyton-louden 

You could use the make columns tool

[binu_acs]

@peyton-louden Another way of doing this. @Luke_C nicely done with one tool!!!

[peyton-louden]

Both solutions worked great. Thanks so much for the quick response!

[ddiesel]

Wow! @Luke_C I never think of the Make Columns tool. This is brilliant!