View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DKS DKS is offline
external usenet poster
 
Posts: 103
Default Pivot table in column format

In my pivot table, I have 2 fields in the DATA area. By default .xls puts
them as rows (the values displayed vertically). I prefer to have column
views, ie the values displayed side by side. How can I drag-drop the data
fields to have a column view?