I am already doing a case statement to get to where Im at right now for the columns. The original data is in one column so I have split it into multiple columns, but dont know how to go from there.

Thanks