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
|