sort alphabetically and numerically, then sort rows

I have been on here before trying to solve an issue that I have with a file that I am trying to make. I am trying to sort multiple columns of data by the letters contained within them and then by the numbers that are in them. After that is executed I would then like to take the sorted information and filter it even further by keeping all of the like number in the same row all the way across, if certain columns do not have the numbers other columns have I would like for a black fill to appear in that box. Can anyone help me out... I have attached a file to better explain what I am trying to accomplish the unsorted tab is the before and the sorted tab is the result that I am looking for. Thanks