Question d’entretien chez Bloomberg

How to structure the data when it is messy?