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.

--
Regards,
Tom Ogilvy

"Bojana" wrote in message
...
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

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 EditPaste 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


Bojana wrote:
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



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html