For my project, I ideally would like to create a pie chart. With what I read online I can’t do that with the variables I have now, so I created a table with two columns. First column, called names, consists of a full name, while the second column, called changes, consists of multiple variables that are separated by a semicolon. For the changes column, I need to separate each variable into a row of its own but still have it associated with the name. What can I do to achieve this?
The end goal is it use this table to see what names are associated with the changes column a distinct number of times. Like Name McName is associated with "No Changes" 37 times. I also created summary report with the same variables but I'm not sure how to proceed with that either.
I'm open to suggestions! Thank you!
