Pivot table

G

Guest

I have more than one value in the DATA area of a pivot table. By default
EXCEL creates the pivot table with multiple rows for the data value (1 row
per field in the DATA area). I would like this to be one column per field in
the DATA area.

Usually I change this by dragging dropping fields from the tab containing
the pivot table. But this drag-drop exercise is frustrating as I am not sure
where exactly to position the cursor before doing drag-drop.

Are there other better techniques to achieve the same objective?

Many thanks in anticipation.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem inserting calculated pivot fields into Pivot Table (2007) 1
Pivot ... Drag Multiple Fields from Field List? 1
Formula fields in Pivot table reports? 2
Changing Default Function in Pivot Tables 1
Formula fields in Pivot Tables? 1
Pivot table filter list - listing irrelevant subcategorys 1
Summing Formula fields in Pivot Tables? 3
Different ways to build Pivot table 1

Top