Select Analysis: Data Manipulation: Reduce by Group… menu.
By Reference Column(s) option is added in SubGroup method dropdown list.
Choose it and specify Reference Columns
Check Output Group Info.
See the output columns from E to H. E&F are averages of XY data within each group. Column G&H are group information.