View Single Post
 
Old 05-09-2018, 09:31 AM
Jamal NUMAN Jamal NUMAN is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Nov 2010
Posts: 615
Jamal NUMAN is on a distinguished road
Question

Quote:
Originally Posted by ArviLaanemets View Post
You can't get cell values as Pivot Table values - they must be either Sum, Count, Average, Max, Min, Product, Numbers count, StdDev, StdDevp, Var or Varp of COLUMNS values.

As Pivot Table is 2-dimensional as max, with 3 fields you have to decide, do ROWS or COLUMNS have 2 fields to group. And as values you have to use Count - there is now way you can sum letters, and I can't see a point in summing F1 values too.

You can get the result more like you want, when you add a calculated column where you concatenate values in F1 and F2
Thank you ArviLaanemets for the answer.

I’m not sure if there is other tool that can help performing deriving the result table out of the given table as shown in the screenshot below. It appears that Pivot tool has no such capacity
Attached Images
File Type: jpg Clip_190.jpg (103.1 KB, 18 views)
Reply With Quote