Urgent Request: Pivot Table Help

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

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

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!

"Dave Peterson" <petersod@verizonXSPAM.net> wrote in message
news:438DCB9F.6497738A@verizonXSPAM.net...
> 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 wrote:
>>
>> 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