Group By Rows summing up ALPHA columns

[srikant]

Group By Rows summing up ALPHA columns . having a hard time converting this input into . What command should i use to collapse data ?

	A	B	C
100	X
200		Y
200			Z

this output 

	A	B	C
100	X
200		Y	Z

[pcatterson · Accepted solution]

I'd approach this with a summarize tool.  But if the situation is more complicated, I am unsure how this should be accomplished.

[andre347 · Accepted solution]

I used a combination of the Transpose, Crosstab and Unique tools to get to the desired results. I've attached the workflow.

Let me know if you need more information

[srikant · Accepted solution]

I used SUMMARIZE with CONCAT ( group by ) and it worked . Did not realize the CONCATENATE command does this . WOW !!!!

Will also try your suggestion which might be more robust for other complicated situations 

Thanks