Excel pivot table make row headers as fields not the column headers

Question

See the following table. When I select the range and then insert Pivot table, Excel by default makes the months (June-11, Jul-11, etc.) as fields not the row headers (Cost, Revenue, Tax and Profit). Is there any way I can directly make them the fields rather than manually transpose the table.

enter image description here

Punith · Accepted Answer · 2015-07-20 08:33:56Z

1

Are you looking for this. if yes then drag values to row headers.

enter image description here

answered Jul 20, 2015 at 8:33

Punith

7024 gold badges12 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mohsen Over a year ago

Thanks for the reply. I'd like cost, revenue, tax and profit to be the fields not the months.

Collectives™ on Stack Overflow

Excel pivot table make row headers as fields not the column headers

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related