Same list sorted 2 ways at the same time

I have a list of 50 items with 50 locations. I would like to show the items in order with the location they are in (not all items have a location)in columns on the left. On the right I would like to show all the 50 locations and what is in that location. I only want to enter the information in the left cols.