ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Tables (https://www.excelbanter.com/excel-discussion-misc-queries/149776-pivot-tables.html)

Elise148

Pivot Tables
 
I have a Pivot Table and I have used "count" functions for three fields for
the middle data area of the Table. To get each of the three fields in their
own column, I clicked and dragged the column heading ("data"). Now I need to
un-drag the fields to get them all back in one column. How can I do this????

Elise148

Pivot Tables
 
Nevermind. I got it!

"Elise148" wrote:

I have a Pivot Table and I have used "count" functions for three fields for
the middle data area of the Table. To get each of the three fields in their
own column, I clicked and dragged the column heading ("data"). Now I need to
un-drag the fields to get them all back in one column. How can I do this????



All times are GMT +1. The time now is 03:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com