Group By Rows summing up ALPHA columns

Question

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

ABC100X  200 Y 200  Z

this output

ABC100X  200 YZ

Groups Rows by Bucketing Columns.xlsx

pcatterson · Accepted Answer

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 Answer

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 Answer

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