I need to create a matrix in Excel that doesn't aggregate (e.g. Sum/Count) values. The question of how to do this has been asked dozens of times online over the last couple of years, but still there is no solution. Can Excel therefore produce a plain matrix, or allow pivottables to output plain (unmodified) values from the data field list?50 votes
- Don't see your idea?