Forum Discussion
Pivot and Null Values
For me it worked using Pivot.
This is the data I used:
Then I used pivot column on ColumnB with values from ColumnC
And this is the resultI have the same problem, and using the sum feature, I get null as my values. I start with
And then when I pivot the Yield Item column, I get
It pulls the values for the first column, but then every other column that is added from the pivot step shows as null. Any ideas?
I know this question is a few years old, but I was just having the same issue and was frustrated that the accepted "answer" here doesn't actually answer anything. I found out through trial and error that the table I was pivoting from had too many columns of data which was throwing the pivot function off and leading to multiple rows and null values. To fix this, I duplicated the original dataset and deleted every column except those being pivoted and an ID column I could use to relate to the original dataset. Make sure you apply the changes then go to Model View to create a two-way relationship between the IDs.