View Single Post
  #10   Report Post  
Old January 14th 17, 04:36 PM posted to microsoft.public.excel.misc
[email protected] 4815162342.mn@gmail.com is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jan 2017
Posts: 1
Default Using text values in Pivot Tables

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.