Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table: How can I organize data items in a row?
Hi,
I am trying to build a pivot table which has categories only in row fields but not in column fields. Instead, the data items should be organized in columns instead of rows. For example, this is what I have now with two data items (habitants and location): inhabitants Country location --------------------------- USA 240 America Britain 60 Europe Japan 120 Asia But I want this: Country inhabitants location ------------------------------------- USA 240 America Britain 60 Europe Japan 120 Asia I can't find a way to organize the data items in a row next to each other instead of below of each other. Any idea? Thank you. Jenny |
#2
|
|||
|
|||
Select the relevant data field in your pivot table, right click, "field
settings", "layout", and click "show items in tabular form". Alternative click on the pivot table and select from the menu; format, autoformat, then select from the pre-prepared layouts available. Sandy. " wrote: Hi, I am trying to build a pivot table which has categories only in row fields but not in column fields. Instead, the data items should be organized in columns instead of rows. For example, this is what I have now with two data items (habitants and location): inhabitants Country location --------------------------- USA 240 America Britain 60 Europe Japan 120 Asia But I want this: Country inhabitants location ------------------------------------- USA 240 America Britain 60 Europe Japan 120 Asia I can't find a way to organize the data items in a row next to each other instead of below of each other. Any idea? Thank you. Jenny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining two data sources in a Pivot table. | Excel Discussion (Misc queries) | |||
Pivot Table Data Field Query | Excel Worksheet Functions | |||
How do I get a pivot table to sort based on the data items sectio. | Excel Worksheet Functions | |||
Pivot Table Data | Excel Worksheet Functions | |||
Need Formula to display pivot table source data | Excel Worksheet Functions |