Pivot table
 

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.

Pivot table
 

See here for info on how to fix your layout:
http://www.contextures.com/xlPivot02.html

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"DKS" wrote:

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.

Pivot table
 

Thanks Dave. This has made my life a lot easier.

"Dave F" wrote:

See here for info on how to fix your layout:
http://www.contextures.com/xlPivot02.html

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"DKS" wrote:

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.