Pivot text values

  • Thread starter Thread starter Tomas C
  • Start date Start date
T

Tomas C

Howdy Folks,

Is it possible to pivot text values in Excel? From what I can tell, the
answer to that is "no." However, I would imagine that scenarios that
require pivot tables that include text come up on a semi-regular basis.
How do you handle those occasions? Thanks in advance for any help.

Tom
 
You can do counts on text values in a pivot table, like counting all the
clients in a state or country.

If you're talking about mathematical functions on words like one hundred or
one the answer would be no.
 
I'm actually not looking to perform mathematical functions on the data,
although Excel insists upon it. I have groundwater chemistry results in
a database format that I want to convert into a more easily-read
cross-tabbed table. In some cases, those results have a letter qualifier
associated with them. If I could get Excel to just CrossTab the data and
not try to summarize it, I would be ever so happy. Any ideas? Many thanks.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Chart - Excel 2013 - Rotating Second and Third Lines of text onthe Horizontal Axis 0
Using text values in Pivot Tables 5
Question on the occupied field of the pivot table in excel spreadsheet 0
Pivot Table won't Get 'r done 1
Pivot Text 1
about pivot table 1
Single Filter to change all Pivot Tables in a Workbook 8
Formula fields in Pivot Tables? 1

Back
Top