Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
I want to import this data into a table that has a personId column and a column for each of the item above that is separated by 2 spaces. How can I do that in query? Thank you. the entries in the table inserted to would have something like this for above:
"Breast Sarcoma Head and Neck Prostate Malignancies"
personID Treatment area 10001 Breast 10001 Sarcoma 10001 Head and Neck 10001 Prostate Malignancies