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.