I’m getting in a mess with a pivot and need advice.
I have a data set with title rows of:
column A - free text surveys responses.
Column B- indication if the response in A is Positive, Negative, Mixed
Column C onwards - I have added a single word on the title row (eg, pay or clean etc) and run a formula to check false/true if that word appears in the free text comment in the corresponding row.
I now want to run and arrange pivot in a table to show the number of P/N/M responses (simple and done), but to then get a break down on top of that of how many True responses of each category sat in the P/N/M categories so I can then say ‘of the X number of negative comments, so many mentioned pay, so many mentioned cleanliness etc.
The trouble is that the Y/N nature of columns C onwards gives me an extra layer to filter in and I can’t filter out all the N returns.
I want a column in my pivot labelled ‘pay’ against rows marked PNM, but I’m getting columns labelled T/F and pay shunted away, as I lay more of source data columns C onwards on the table it gets confusing to see which pivot column is which and I can’t filter out the False data for all of them.
I have a data set with title rows of:
column A - free text surveys responses.
Column B- indication if the response in A is Positive, Negative, Mixed
Column C onwards - I have added a single word on the title row (eg, pay or clean etc) and run a formula to check false/true if that word appears in the free text comment in the corresponding row.
I now want to run and arrange pivot in a table to show the number of P/N/M responses (simple and done), but to then get a break down on top of that of how many True responses of each category sat in the P/N/M categories so I can then say ‘of the X number of negative comments, so many mentioned pay, so many mentioned cleanliness etc.
The trouble is that the Y/N nature of columns C onwards gives me an extra layer to filter in and I can’t filter out all the N returns.
I want a column in my pivot labelled ‘pay’ against rows marked PNM, but I’m getting columns labelled T/F and pay shunted away, as I lay more of source data columns C onwards on the table it gets confusing to see which pivot column is which and I can’t filter out the False data for all of them.