Data Organization - Tables-Queries Set Up

[Roy Hobbs]

I have tried to set up my data a couple of different ways but I seem to keep reaching the same road block. I can visualize my end report but can't get there.

My data is confidential work related but let me use an equivalent example. I am trying to create a database that tracks the winning bidder of the Olympics along with 2 losing bidders.

Year Winner Loser1 Loser2
2018 Winter Pyeonchang Munich Annecy
2016 Summer Rio Chicago Tokyo
2014 Winter Sochi Salzburg Pyeongchang
2012 Summer London Moscow Paris


2010 Winter Vancouver Pyeongchang Salzburg


Ultimately, I want to create a winning percentage for each city. Though this data is skimpy, Pyeonchang is a good example of my troubles. It has 1 winning bid and 2 losing bids, and also the losing bids are in 2 different columns.

Any suggestion?
Thanks

[ranman256]

The way you show the data is not how you store it. But that is the end result.
the table is:
year, person, place

then, a query would pull the top 3.
the use a Crosstab to get your report above.