Maximum of Multiple values over one dimension

[EngMaher88]

Hi All, In my data source i have a table like below,

ID	Cell	Traffic GB
1178	1	0.0
1178	2	0.0
1178	3	0.1
1178	4	0.1
1178	5	0.5
1178	6	0.7
1178	7	0.9
1178	8	3.2
35536	1	0.0
35536	2	0.0
35536	3	0.1
35536	4	0.1
35536	5	0.1
35536	6	0.1
35536	7	0.3
35536	8	0.3
35536	9	0.3
35536	10	2.6

my objective is to get the max value for each ID with its corresponding cell as shown in the table like below,

ID	Cell	Traffic GB
1178	8	3.2
35536	10	2.6

any idea please 

[joaopaulo_delco]

Hi @EngMaher88 !

    It's very easy to do. 

Column 1: ID

Column 2: Max(Cell)
Column 3: Max([Traffic GB])