how do I repeat field value in a pivot table?

[jvittone]

In a pivot table, the value field is not repeated on each line. For further
investigation purpose (needing for example a sort on the field) I would like
to have this value repeated on each line. How could I do this?

 

[Dave Peterson]

It's not possible if you still want to keep it as a pivottable.

But you could copy it and paste special|values (to another location) and fill
the empty cells using techniques from Debra Dalgleish's site:

http://www.contextures.com/xlDataEntry02.html

But this copy won't be a pivottable anymore.