Urgent Request: Pivot Table Help

[David Lipetz]

I'm building a Pivot Table and for the life of me can't figure out how to
put items in the Data Area in a columnar fashion rather than stacked rows.

I've done it before but can not recreate it. In fact, I have an older Pivot
Table setup in this fashion but can duplicate how I did it.

Want CUSTNO as the ROW AREA, then another 6 or so fields in the DATA AREA
but want everything on one row.

Your assistance would be greatly appreciated!!

David

 

[Dave Peterson]

Take a look at Debra Dalgleish's site:
http://www.contextures.com/xlPivot02.html

She's got nice pictures of how to drag the "button" to the right.

 

[David Lipetz]

OUTSTANDING!! Thank you VERY much! Can't believe the answer is so simple.
Will bookmark this terrific reference site.

Thanks again - you saved my day!