Pivot tables, using rows instead of columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Depends on what you want to do, but generally, the answer is no. What you
have is what a pivot table normally produces.
 
No, the headings for the pivot table source data must be in the first
row. If you have fewer than 256 rows of data, you could transpose it
using Edit>Paste Special, Transpose.

Or, if the data is all numerical, use the "unpivot' technique described
by John Walkenbach:

http://j-walk.com/ss/excel/usertips/tip068.htm
 
Back
Top