|First, a posting tip:|
If you click on the blue line at the end of this response you'll find the instructions on how to post data in this forum so that your columns will stay lined up.
As for your question, how about this:
Put all of your #'s and Appearance data in Columns A and B (A1:B46)
In D1:M1 put the Column Headings as you have posted above.
1 - In D2 enter =A2. Drag it into E2, then drag both cells down to E11.
2 - In F2 enter =A12. Drag it into G2, then drag both cells down to G11.
3 - Continue this process until you have a table of formulas that basically spilts your list of 45 numbers into the 5 sets of numbers that you have above.
4 - Select this table and set it as the Print Area
5 - Sort Columns A & B, keyed on Column B (Appearance)
Your table will reflect the sorted data and you can print it.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.