I need some help converting my data from multiple values in one text field into a chart. Firstly, I have split my fields allowing me to enter multiple answers in a single field as below:
However, I need to convert these answers into a chart and currently its recording “cats” twice as it’s the first answer I have entered, when actually it should be 1 count of 'cats' and 1 count of 'dog'. Does anyone know how to rectify this?
Thanks in advance