how to sort grouped data?

Originally Posted by Ali Kırksekiz

For G3

=IF(ROWS($J$3:J3)<=COUNT($C$3:$C$234),SMALL($C$3:$C$234,ROWS($J$3:J3)),"")

For H3

=INDEX($B$3:$B$234,LARGE(IF($C$3:$C$234=G3,ROW($C$3:$C$234)-ROW($C$3)+1),COUNTIF($G$3:G3,G3)))

This in an array formula and so must be confirmed with CTRL+SHIFT+ENTER and not just ENTER.

may I ask what is in column J? it is blank
thanks!