software

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?

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 MVPquot;Martyquot; gt; wrote in message
...
gt;I am trying to use data in an Excel pivot table in another application, but
gt; am finding that data sorted by row, where multiple lines are available for my
gt; first sort on row the row label only displays against the first line, not
gt; subsequent lines. How can I get it to display against each line?