The Ribbon is at the top of the Excel window, where you should see the
tab names, e.g. Window, Insert, Page Layout, Formulas, etc.
Sometimes, additional tabs are visible. For example if you select a cell
inside a pivot table, you should see two new tabs -- Options and Design.
Above those tabs is the heading, PivotTable Tools.
It sounds like you right-clicked on a cell in the pivot table.
In the Field Settings dialog box, select 'Show item labels in tabular
form', and the first part desc will be on the same row as the part number.
That setting is the same as selecting 'Show in Tabular Form' on the Ribbon.
John13 wrote:
> On Feb 15, 8:42 am, Debra Dalgleish <d...@contexturesXSPAM.com> wrote:
>
>>Select a cell in the pivot table.
>>On the Ribbon, click the Design tab
>>In the Layout group, click Report Layout, and then click Show in Outline
>>Form or Show in Tabular Form
>>
>>
>>
>>
>>
>>John13 wrote:
>>
>>>Being new to 2007, I am having trouble with Pivot Tables. I have four
>>>columns of data, Part Number, Part Decsription, Item Class and Shipped
>>>Quantity. When I go into pivot table I can't get the pivot table to
>>>have Part Number in one column and Part Description in the next column
>>>like Excel 2003 would do, they are in the same column in every other
>>>row.
>>
>>>Part # Desc Class Quantity
>>>123 Part A 50 45
>>>124 Part B 50 63
>>>125 Part C 50 29
>>>126 Part D 50 54
>>>127 Part E 50 87
>>>128 Part F 60 69
>>>129 Part G 60 59
>>>130 Part H 70 21
>>>131 Part I 70 36
>>>132 Part J 70 47
>>>123 Part A 50 45
>>>124 Part B 50 63
>>>125 Part C 50 29
>>>126 Part D 50 54
>>>128 Part F 60 69
>>>129 Part G 60 59
>>>130 Part H 70 21
>>
>>>What am I doing wrong please? I appreciate any help here. Thank you
>>
>>>John
>>
>>--
>>Debra Dalgleish
>>Contextureshttp://www.contextures.com/tiptech.html- Hide quoted text -
>>
>>- Show quoted text -
>
>
> Thank you Debra for your quick response. I couldn't see a Design Tab,
> no matter what I clicked on (and not sure what the ribbon is). If I
> click Part Descriotion I can get Field Settings and a Layout & Print
> tab and click off the same column check for compact form, but I still
> have the part number on one row and the Part Desc on one row below but
> in column B and the Qty is on the same row, but in it's own column.
> Can I get everything to one row like Excel 2003? Again thank you for
> your help. I really appreciate it.
>
--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html
Similar Threads
