Hi,
I have a dataset that I'm working on that I've gotten down to two distinct columns. I've made a simplified version for testing how I want to rearrange the data, and I'll attach it. The first Text Input is how my data looks now, and the 2nd one is how I want it to look. How can I accomplish this?
Solved! Go to Solution.
Hi @Steve1,
You could use a Summary tool, group by Field1 and Concatenate Field 2. Then run that into a Text to Columns tool to split the concatenation into columns. The output from that should give you what you need with minimal cleanup.
Hope that helps!
John