Bloomberg Interview Question

How to structure the data when it is messy?