Bloomberg interview question

How to structure the data when it is messy?