Combining Rows

[NBPSE]

How do I combine these two rows so I have one row with 200 in one column and 100 in the other?

1  10   0     100

2  10  200     0

[Gaurav_Dhama_]

Add a summarize tool and take max of each item. First column has same number, so it will result in 10, other two will result in 200 and 100 respectively, and all in a single row.

[aatalai]

@NBPSE I assume the first column is a record id? If so you would need to transpose the data, the first field being a key column and the rest should be data columns then use the summarize tool group by field 1 and get the max value. Please elt me know how you get on

[NBPSE]

This didn't work for me. I have many columns and when trying to transpose it only allowed me to transpose 3 columns.

[aatalai]

@NBPSE can you take a screenshot of the transpose tool and it's configuration please? As I would suggest selecting the fields in the transpose tool, but suprised that it doesn't let you

[Gaurav_Dhama_ · Accepted solution]

This should take care of any number of columns

[Pilsner]

Hello @NBPSE 

I've tried to combine the rows using the summarise tool.

If you group by your first column, then highlight all your other columns and click sum.

You should get the following answer.

I have attached the workflow below, if you have any questions please let me know. 

Regards - Pilsner