I am looking for a query which returns the results as follows:
All choices for an answer are returned in the order the answer choice is listed in the pipe delimited field with a count of the number of responses. So for the above it would look like: