Summarize based on a filed

[Beginner123]

Trying to summarize based on Transaction number but data is in different rows 

Current

Transaction No	From Company	From Portfolio	From Trading Philosophy	From Subfund	To Company	To Portfolio	To Subfund	To Trading Philosophy	Lot Level Unit
20230714007538	0001	ABCDEFG	XYZ	127					10000000
20230714007538					0001	ABCDEFG	127	XYZ	0

Required

Transaction No	From Company	From Portfolio	From Trading Philosophy	From Subfund	To Company	To Portfolio	To Subfund	To Trading Philosophy	Lot Level Unit
20230714007538	0001	ABCDEFG	XYZ	127	0001	ABCDEFG	127	XYZ	10000000

[TimN]

Here's one way...

[AndrewDMerrill · Accepted solution]

The Summarize Tool is all you need. For Aggregation, you can use "Longest" to capture all string data, and for numerical fields, whatever gets the number you need.