Hello,

As seen in attached file (hopefully its attached)<
I have a table of 6 products showing the awareness of each product either as “aware”, “not aware” or “blank”.

I am trying to make a pivot table as seen here

Is there a way to do this as i can only seem to do it for one category at a time rather than all at once. Thanks!

– on Excel PC Version 2405

​Hello,As seen in attached file (hopefully its attached)<I have a table of 6 products showing the awareness of each product either as “aware”, “not aware” or “blank”.    I am trying to make a pivot table as seen here Is there a way to do this as i can only seem to do it for one category at a time rather than all at once. Thanks!- on Excel PC Version 2405  Read More

​