Merging three rows

[Anjankumar2021]

Hi All

could someone please assist on below issue?

Input:

Product	Count	Batch	Rating	Value	Val	rating -1	Age	Aval	rating -2
Samsung	331	3	L3	[Null]	[Null]	[Null]	[Null]	[Null]	[Null]
Samsung	[Null]	[Null]	[Null]	-148480035.2	5	L5	[Null]	[Null]	[Null]
Samsung	[Null]	[Null]	[Null]	[Null]	[Null]	[Null]	100	1	L2

required output:

Product	Count	Batch	Rating	Value	Val	rating -1	Age	Aval	rating -2
Samsung	331	3	L3	-148480035.2	5	L5	100	1	L2

[binu_acs · Accepted solution]

@Anjankumar2021 Add a summarise tool and select all field for the Max value 

[binu_acs · Accepted solution]

@Anjankumar2021 

[Anjankumar2021]

thank you so much:)