I need some help in trying to figure out how to develop the below graphic. I have race data in a spreadsheet (notional example below) with runners in rows and the columns representing mileage segments with the time it took to complete the segment. To get to the graphic the hard way would be to go row by row and highlight the cell with the fastest mileage segment. Then using the data tab, go mileage segment by mileage segment selecting only the highlighted blocks, then calculating an average finish time for those highlighted segments. I'm sure Tableau would be able to do this, I just can't figure out how. Anyone got any ideas?
|Name||Gender||Age||Finish Time||5k Time||10K Time||15K Time||20K Time||25K Time||30K Time||35K Time|