When handling survey data, you may encounter situations where multiple responses are stored in a single column, separated by a specific delimiter.
In such cases, you can easily aggregate the responses by splitting the values into separate rows.
For more details, please refer to the explanation provided in the link below.