Display Row label covering multiple lines in Excel Pivot Table

[Guest]

I am trying to use data in an Excel pivot table in another application, but
am finding that data sorted by row, where multiple lines are available for my
first sort on row the row label only displays against the first line, not
subsequent lines. How can I get it to display against each line?

 

[Bernie Deitrick]

Marty,

Select your pivot table, copy it, then paste values elsewhere. After pasting, do not change your
selection, and use Edit / Go To... Special Blanks, then type =, press the up arrow key once, press
Ctrl-Enter, then re-select the entire table and copy/paste values again.

HTH,
Bernie
MS Excel MVP