Help Gurus! Pivot Table Text as Data

  • Thread starter Thread starter Rafael
  • Start date Start date
R

Rafael

Is there a way to output a Text value in the Data area of
a Pivot Table?

For example, the pivot table I want is something like
this:

5/1 5/2 5/3 5/4 5/5 5/6
task1 brad jeff
task2 ann tony mike john
task3 clint nick lori
task4 tina pat

Thanks in advance to everyone.

Rafael
 
Rafael,

This isn't the purpose of a pivot table. It groups things, and does a
calculation for each group (sum, average, etc.). You need to make the table
you need yourself. How that's done depends on your source data.
 
Back
Top