Creating aggregate excel

looks like a group by case and aggregate the group members