Formatting pivot table data

[Walkon]

Good morning,

I am displaying pivot table data in the "Classic" format. When I click the +/- button in the FullName column, the R_FullName(s) appear in their own column as I want however the first one displays one row down from the FullName row (please see the image titled UN-preferred format 3). I have am hoping to have the two names appear with one on the same line as the "FullName" (see first image titled Preferred format 1), and the second one to appear immediately below it. This is a significant space saver. I've tried a few of the options that appear when I right click in the pivot tale but with no luck so far. Any suggestions as to how to make this happen greatly appreciated. Thanks.

 

[GlennUK]

Are you sure there aren't blank entries in the source data that are coming through?

 

[RoryA]

Did you select the option to show item labels in outline form e.g. to display subtotals at the top of each group for that field? That would cause the layout you posted.

 

[Walkon]

Are you sure there aren't blank entries in the source data that are coming through?

Good morning,

Thanks for responding. To be honest, I am not sure, but I don't know where they would be. I have attached an image of the data table the info is being pulled from. Is there another location that where the blanks may be? Thanks again.

 

[Walkon]

Did you select the option to show item labels in outline form e.g. to display subtotals at the top of each group for that field? That would cause the layout you posted.

Thanks very much! Sorry for the delay in responding, I was out of the office.

 

[GlennUK]

Good morning,

Thanks for responding. To be honest, I am not sure, but I don't know where they would be. I have attached an image of the data table the info is being pulled from. Is there another location that where the blanks may be? Thanks again.

Do you have a count in the data area for that blank row? If so, double-click it, and a drill-down to the subset will generate a new sheet of that subset of records.