View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bojana Bojana is offline
external usenet poster
 
Posts: 6
Default Pivot tables, using rows instead of columns

All,

is it possible to select a range for pivot tables where data are ordered in
rows instead of columns?

Example
Year1 Year2
Revenues 10 20
Costs 5 4
Interest earned 1 1

Normally pivot table wiz does not accept such range, complaining about the
upper left empty cell. Is it possible to use such "horizontal" ranges?

regards,

Bojana