ContributionsMost RecentNewest TopicsMost LikesSolutionsRe: How to pivot this data table? Thank you lalasisi for this post. I too, am experiencing a similar problem. I think it is the default nature of pivot tables, regardless of technology, to not allow non-aggregated values in the Values section of a pivot. Hoping someone can provide a method, maybe it is JavaScript or something to force non-text values into the proper section of your pivot.