Summarize a huge table

[Lerk]

Hi,

How can I use alteryx to summarize a tableau with 150 columns? 

I have account number down on the "y-share" in my table and a 150 company names on the "x-share". I want to summarize all the different amounts for each company on each account number. 

Ex

Account number | Comapny 1 | company 2 |

12000 | 1,000 | 2,000| = 3,000

12100 |1,000 | 2,000| = 3,000

I have tried to use transpose but it want work. Could someone please help me? 

[Krzysiek · Accepted solution]

Hey

It sounds like "Summarize Tool" with following setup:

1) Group by - Account Number

2) Sum of respective columns containing companies.

Like so:

[Raj · Accepted solution]

@Lerk 
find the workflow attached
made this dynamic for n number of columns
Mark done if solved.