summarize columns dynamically

[tanvir_khan]

Hi all:

I'd like to prepare output from the input table below. I can do this using summarize tool.

But there may be additional column(s) appear in future. How can I summarize those additional columns as the summarize tool doesn't have dynamic or unknown column features. Is there any alternate way? 

Input

Output

Thanks

[Matt_D · Accepted solution]

Hi  @tanvir_khan you would transpose then crosstab, ensuring in Transpose tool your non aggregation columns were selected as Key Columns, then ensure that Data Columns selected included "Dynamic or Unknown Columns",  then in Cross Tab tool on group by Key Columns,  Name as your Headers, Value as your New Columns, Sum as your aggregation.

If 12 new aggregation columns popped in, they would get summarised.

Example workflow attached which will generate a random mount of columns each time it's ran.

[tanvir_khan]

Thanks @Matt_D 

Hey instead of marking your reply as solution, I mistakenly marked mine. Do you know how to revert it?

[Matt_D · Accepted solution]

Hi @tanvir_khan  no idea but it is OK, I'm not precious about that, as long as you know what you're doing now I'm happy to help. 😎