Pivot tables require data to be stored with rows as records.

If you need a different layout for display, perhaps you could start with the
source data in the proper orientation and use links or a pivot table to
generate a display view on another sheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"R Vaughn" <R wrote in message
...
When setting up the source data in a pivot table, is there a way to assign
rows as fields and columns as records? Excel automatically sets each row
of
the source data as a record with field names located in the top cells of
the
columns. I typically prefer this standard layout, but sometimes find it
useful to store and display source data with the columns as records.


"Jim Thomlinson" wrote:

Check out this link...

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
HTH...

Jim Thomlinson


"Eric Svatik" wrote:

I need to make a pivot table, how do i go about getting that started
correctly?