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 |
Pivot tables, using rows instead of columns
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 |
Pivot tables, using rows instead of columns
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 |
All times are GMT +1. The time now is 09:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com