Misterious (to me) Pivot Table View

WHP3III

New Member
Joined
Jan 6, 2019
Messages
1
Someone sent me an Excel file containing a single pivot table. A dozen fields reside in the pivot table field list within the ROWs box. One field resides in the VALUEs box. All of the ROW data fields (names) appear in the pivot table as columns, including the single 'value' field. I've never seen anything like it, and I can't replicate it. The file is an anomoly to me. I've never seen any pivot table display ROWs data in columns unless the field is dragged or moved from the rows box to the columns box. The pivot table layout is 'standard', not tabular, not compact, not special. I have a pdf image of this, but I'm having a hard time posting it. https://www.dropbox.com/s/90gqm7kajkp21fu/Excel Image Problem.jpg?dl=0

Excel%20Image%20Problem.jpg


Excel%20Image%20Problem.pdf
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

Forum statistics

Threads
1,223,956
Messages
6,175,613
Members
452,661
Latest member
Nonhle

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top