Split up a column into multiple columns in MySQL database?

That’s what I’m trying to do:

How would I be able to do that?