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!
