How to reorganize and sort the data to get top 3 value of each group

Hello,

Some of our customers have their own specific price list and I need to reorganize it to make a standardized price list by level. For example, if an item 'Uniform A' is in many of our customers price list, I'd like to get the top 3 values and put the price information in those new three pricelist, let's call it 1) Gold 2) Diamond 3) Platinum for convenience.

What makes it more complicated is that I want to exclude the specific price that is applied to only one or two customers because that doesn't really represent the general pricelist.

The data structure I have looks like this:
1.PNG

And what I need to see in the final version looks like this:

2.PNG


Would there be an efficient way to reorganize the data? Please help me. You can find the real data in the link. I've done my best and you can find the order of my work under each tab.

https://drive.google.com/file/d/0B6f...ew?usp=sharing