Pivot Table Grouping

[#1]

Guys I'm stuck at making a pivot table. Below is the screen cap of it.

I'm trying to show server inventory, and you can see last 2 columns are duplicated after memory columns. Is there a way I can only show those 4 disk drive utilization columns only once for each server? I really couldn't find a way to do it.

Thank you very much for your help.

[settu_periasamy]

Have you tried to interchange your last two columns and check?

[avinashelite]

change the column ordering of the Server and disk drive that should solve the issue

[#4]

Hi settu_periasamy,

Thanks for your reply. I tried and it won't help. It seems to me that in a pivot table, once it's split into 2 rows for one single record, all data belonging to that record afterward will be represented in at least 2 sets. In this example, disk utilization data is duplicated from memory utilization.

[#5]

Hi Avinash, thanks for your reply!

However, seems like it won't work. In fact I did try changing the order of my data, but It seems to me that in a pivot table, once it's split into 2 rows for one single record, all data belonging to that record afterward will be represented in at least 2 sets.

Here is actually the full capture of my table in which I followed your suggestion. Am I still doing anything wrong?