Two issues: building a list from an array of data and looking up in an array against list

I am building a list of customers looking to buy widgets with unique piece #'s. For each customer they are asked to rank the widgets from their top pick to their bottom pick.
I ranked each customer based on his/her importance to the company. I need to reverse this table and have a list of the piece #'s and each customer associated with that piece but in order of how I ranked them and how they ranked the piece. Please see attached.
Avoiding VBA would be ideal here.