Separate data on different columns

I currently have a data base with raw data that contains SS numbers, names and appointment dates. How ever, its transferred from another program which populates all data in the same column. I've been...