Pivot table-Displaying multiple Row Labels on one line

[Excel Chimp]

I'm trying to have "2000 Central Parkway" display to the right of the "Carrington Park-2990" field, and so on for the other addresses below. I'm stuck. Any ideas? Sorry but I'm a novice at Pivot Tables.




-- removed inline image ---

Excel Workbook
	A	B
1	Region	(All)
2
3	Row Labels
4	AL
5	Midwest
6	Carrington Park-2990
7	2000 Central Parkway
8	AR
9	Midwest
10	Avondale-3047
11	1812 Reservoir Blvd.
12	Enclave at the Riverfront-3816
13	75 West Riverdrint Drive
14	Ranch at Pinnacle Point-3448
15	5900 Stoney Brook
16	Sunset Village-3469
17	2611 W. 34th Street
18	AZ
Sheet3

Excel 2010



-- removed inline image ---

 

[Excel Chimp]

I generated the picture from the Mr Excel HTML tool, but it is not displaying the pivot table detail properly.

 

[Trouttrap2]

Without knowing how your data is setup, its hard to know how the pivot is responding to your data. First though, set your pivot table in classic view. To do this, go to Pivot Table Options>Display>Select Classic Pivot Table Layout. Then put your region and address in the Row Labels section. See how that works.

 

[Excel Chimp]

Thanks for the reply. I think it had to do with the Report Layout. Once I switched this to Tabular View (Pivot Table tools-->Design->Report Layout->Show in Tabular Form) it fixed it.