I figured it out. Make Case # a dimension & place the pill? in columns. Place the age pill? in rows and set age to average. Then Analysis > aggregate measures. Previously, I was treating Case # as a measure as well, and when I aggregated, it bundled all the cases together, which was tripping me up.