Thread: pivot layout
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
jim
 
Posts: n/a
Default pivot layout

Not sure if this can be done using the Wizard, but once you've set up
your table and begun adding data, drag the gray "Data" box to the right
field "Total" I think. This will place your data in separate columns
instead of rows. As you drag new items to the data field it will
populate a new column.