CODEWITHSUNDEEP
excelpivot
Erg
Erg

Reputation: 69

Excel pivot converts text to zero when numbers in column

I am attempting to pivot some data using Excel; however, the text (non-numeric) values are being converted to zero (0). The format of the cells of the entire worksheet are in Text; I have tried other formats including all cells as General, and a variety of combinations involving both formats. The actual values (including both text and numeric) are visible when selecting the little down arrow that appears to the right of Value when the mouse-pointer hovers over it in the Fields Section to the right of the main field.

What must I do to get the text values to appear?

Pivot Table

Upvotes: 0

Views: 853

Answers (1)

Ron Rosenfeld
Ron Rosenfeld

Reputation: 60389

If there is no more than one value for each Group/Column pair, and if you have Excel 2010 or later, you can use Get & Transform or Power Query to Pivot the Name column and chose the Do Not Aggregatge option.

If you have multiple entries for each Group/Column pair, you will need a different solution.

Upvotes: 1

Related Questions