Trying to rotate column data to be new column headers

[Steve1]

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?

[JohnJPS · Accepted 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

[ponraj · Accepted solution]

Here is the solution for your case. Hope it helps. 

WorkflowResults