I am returning to SPSS after 14 years and I am completely stymied by a project. I was able to get the following string data into SPSS (I have 1600 individual names):
But I would like to transform them to the following so I can do analysis:
name city state
John Smith Los Angeles California
Mary Hall Portland Oregon
Meg Gonzales Orlando Florida
I have looked through all my old SPS files, but cannot find anything to jog my memory or my creativity!
MANY thanks for any guidance.