Forum Discussion
How to create a pivot table to represent categorical text?
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 ...
james231660 First of all you need to get rid of the empty rows in your data range. Then you need to unpivot (flatten) the data so that you end up with one column for Product and one for all the 'scores'. Then you can make a pivot table from that data set. The first two steps can be done in Power Query as demonstrated in the attached file.