View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default how to unpivot a pivotted excel sheet?

Is this based on a range/table in a worksheet?

Find the grandtotal cell
double click on it.

You'll see the data--but it won't be formatted pretty.

alamm wrote:

how to unpivot a pivotted excel sheet?


--

Dave Peterson