Copy multiple fields based on criteria

Just for fun, here's an ARRAY FORMULA* which produces alphabetized lists for each row! Paste in J5, copy across and down:

=IFERROR(INDEX($C$5:$C$17,MATCH(AGGREGATE(15,6,COUNTIF($C$5:$C$17,"<"&$C$5:$C$17)/($D$5:$D$17=$G5),COLUMNS($J5:J5)),COUNTIF($C$5:$C$17,"<"&$C$5:$C$17),0)),"")

NOTE- The COLUMNS($J5:J5) clause points to the cell where you paste the formula. If you alter it, be sure to get the $ dollar sign right.

*Always press CTRL+SHIFT+ENTER to confirm entry after pasting or editing an ARRAY FORMULA in the Formula Bar.
When copying the formula to other cells, make sure the copied cell is not part of the Paste Area.

Please click the Add Reputation star below any helpful posts, and use Thread Tools (up top) to mark your thread as SOLVED once you have your answer. Thanks!-Lee