Formula to transform this data into something that is readable for pivot tables

I have this file where the data comes from an online form. The problem is, the data is lumped into one single cell and I am trying to figure out if there is a single formula that I can use to efficie...