Group items by rating

[mcannally]

I have categories in Col A and a corresponding rating in Col B. Col A is dynamic. Col B is fixed to:Avg,good,new, or null. Not all categories will have ratings (null). I am trying to group the categories by ratings - with specific formatting. See below. Desired result is in B10. The example just has 2 ratings, but there could be 1-3 ratings present (Avg, good, new), or blank. Looking for a non-VBA solution. Thanks!






[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Category[/TD]
[TD]Rating[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Red[/TD]
[TD]Avg[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]Yellow[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Green[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]Blue[/TD]
[TD]Good[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Black[/TD]
[TD]Avg[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]White[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]Brown[/TD]
[TD]Good[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]Result ->[/TD]
[TD]Red/Black/Avg Blue/Brown/Good[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]