I have a table that has a list of clients and attributes, in the form of
Customer | Quantity purchased | State | etc.
Until here everything is fine. The problem is that our customers have responded to a survey and we have compiled the results. Basically, we used this format
Customer # | Attribute 1 | Attribute 2 | Attribute 3 |
Customer 1 | 1 | 0 | 1 |
Customer 2 | 0 | 0 | 0 |
Customer 3 | 1 | 0 | 0 |
I've tried every possible way to create a PivotTable around that (rotate attribute results with sales, reports, etc.), but whenever I add multiple attributes , attributes 1 and 0 are nested. Excel does not recognize them as the same label and makes any analysis impossible.
Here's what it looks like
I know that the ideal configuration is to use a single column and add the attributes to it, but in this case, this is not possible because the clients may have added OR more attributes. That's why I did it in different columns.
Use Power Query to break down all the attributes in one column but leave only the first, the others are lost.
What is the right way to do it?