You need to group by the Name1
data field and then in the newly added Group Header or Group Footer section add text boxes for the other data fields wrapped in the Avg() aggregate function
For more information, please refer to the Grouping Data
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Feedback Portal
and vote to affect the priority of the items