Summarize based on one column

[apaicanada]

Hi all,

I'm having a bit of a basic problem but cannot get the summarize tool to put out what I want right now unfortunately. My table looks like this:

Batch ID	File #	Reg Hours	O/T Hours	Hours 3 code (1)	Hours 3 amount (1)	Hours 3 code (2)	Hours 3 amount (2)	Hours 3 code (3)	Hours 3 amount (3)	Rate Code
2	123456	63.07	3	0	0	10	1	0	0	2
2	123456	63.07	3	15	5	0	0	0	0	2

22222

How can I summarize this and get a table like this? 

Batch ID	File #	Reg Hours	O/T Hours	Hours 3 code (1)	Hours 3 amount (1)	Hours 3 code (2)	Hours 3 amount (2)	Hours 3 code (3)	Hours 3 amount (3)	Rate Code
2	123456	63.07	3	15	5	10	1	0	0	2

Any help is greatly appreciated!

Thanks so much,

Akarsh

[PhilipMannering · Accepted solution]

Use a summarize tool as attached.

Workflow to summarize rows

[apaicanada]

Thanks so much - I didn't know about the "Max" summary!

[PhilipMannering]

There are a few different types of aggregations. Maybe the Hours Amount should be summed... I'll let you figure that out, but it's easy to change.