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!
Solved! Go to Solution.
Both solutions worked great. Thanks so much for the quick response!
Wow! @Luke_C I never think of the Make Columns tool. This is brilliant!
User | Count |
---|---|
107 | |
82 | |
69 | |
54 | |
40 |