I have done couple of things.
1- First after reading the file in Tableau I have used data interpreter.
2- Then i have pivoted the data
3- then created couple of calculated field.
Attached is the workbook. Let me know if anything is not clear to you.
ugly_data_v10.3.twbx 135.4 KB