[[email protected]]

This does seem like an oversight on part of google..
I think the pivot should allow text values, and just display #N/A if multiple values match the column/row pair.

Given a table with a "unique key" of two columns, it would be very nice to be able to quickly pivot that into a readable grid.