Show Yes/No As The Values In A Pivot Table In Excel
(2). Finally, double click on the small square on the low right corner of the result (3).
2. Mark the data (1), click insert (2), and then click Pivot Table (3).
3. Click ok
4. Check a label, which in this case is the (name).
Note: Check the unique too.
5. Click and drag name to row, and do the same thing with unique.
Note: The name and unique were dragged here.
The Pivot would look something like this: