Creating a Rankings Table
 

My data comes in like so:

Symbol Firm Volume
QQQQ BOX549 97,349
QQQQ BOX912 95,172
QQQQ BOX919 90,111
QQQQ BOX980 71,068
QQQQ BOX910 37,991
QQQQ BOX642 30,145
QQQQ BOX913 11,514
AAPL BOX910 39,285
AAPL BOX919 34,443
AAPL BOX980 26,750
AAPL BOX549 26,493
AAPL BOX642 24,276

I am trying to create this table of rankings (for example):

BOX549 BOX912 BOX919
QQQQ 1 2 3
AAPL 3 2

I s there a way to pull this off ?

Thank you in advance.