2 Ways to Arrange Pivot Table Columns Side by Side in Excel

To arrange the Pivot Table columns side by side, go through the steps below:

  1. Firstly, hit any cell in the Pivot Table to access the Design tab.
  2. Then, click on the dropdown of Change Report Layout.
  3. Lastly, select Show in Tabular Form option.

By following these steps, you can change the row labels layout in Excel. Finally, you can see the Pivot Table column side by side in Excel.

Default Row Labels in Pivot Table

When we create a Pivot Table in Excel, there are PivotTable Fields to add or remove fields from it. You will see the text data in the Rows area after checking on the fields.

Pivot Table Fields to see row labels to columns side by side in Pivot Table

Here, I have checked on the product name, then the salesman and month in PivotTable Fields. In the Pivot Table, we can see the listed row labels in the same column by default.
By default row labels before making the columns side-by-side in Pivot Table

Now, I want to these row labels in Pivot Table columns side by side in Excel.

Change Report Layout to Set up Pivot Table Columns Side by Side

Let’s learn to change the report layout in Pivot Table in Excel. Change Report Layout option will enable the row labels to be in Pivot Table columns side by side in Excel. To do that, follow these steps:

  1. Click anywhere in the Pivot Table.
  2. Then, go to the Design tab.
  3. Next, hit the dropdown of Change Report Layout.
  4. Now, choose Show in Tabular Form option.
    Selected Show in Tabular Form from Report Layout dropdown in Pivot Table

This will change your Pivot Table layout. It will show the Pivot Table columns side by side in Excel.
Result of Pivot Table columns side-by-side using Show in Tabular Form

Arrange Pivot Table Columns Side by Side Using PivotTable Options

To keep Pivot Table Columns side by side from being in the same column, you can use PivotTable Options in Excel. Here’s how:

  1. Right-click any cell in the Pivot Table.
  2. Then, choose PivotTable Options from the Context Menu.
    Access PivotTable Options to arrange Pivot Table Columns side-by-side in Excel
  3. Next, go to Display tab in the PivotTable Options dialog box.
  4. Now, check on the Classic PivotTable layout and click OK.
    Check on Classic PivotTable layout to make columns side-by-side in Excel

As a result, this will update your Pivot Table columns side by side.
Result of Pivot Table columns side-by-side using PivotTable Options in Excel

Remove the Totals from the Pivot Table

You can notice totals inside the Pivot Table after arranging the Pivot Table columns side by side in Excel. Hence, it gives a messy outlook of the Pivot Table. Currently, we will learn to remove these totals from the Pivot Table.

To do so, go through the instructions below:

  1. Right-click the header cell from which column you want to remove totals in the Pivot Table.
  2. Then, select Field Settings from the Context Menu.
    Access Field Settings to remove totals in Pivot Table in columns side-by-side
  3. Next, choose None in the Subtotals section in the PivotTable Field dialog box and click OK.
    In Subtotals section, choose None to change setting in Pivot table columns side-by-side
  4. Repeat the same process to do that for other columns.

Hence, it changes the outlook of the Pivot Table columns side by side in Excel by following the procedure.
Final Result of Pivot Table columns side by side after removing the subtotals in Excel

Conclusion

When you add many fields in Rows in PivotTable Fields in Excel, you will see them in the same column of the row labels. So, to visualize the data more clearly, it is better to organize the row labels in Pivot Table columns side by side. In this article, I have added 2 ways to change Pivot Table row labels into Pivot Table columns side by side in Excel. Here, you will see the default settings of row labels. Then, you can solve it by following the guidelines. Additionally, you will also learn to organize the Pivot Table columns side by side precisely by eliminating totals within the Pivot Table. Hopefully, this article will help you to arrange the Pivot Table column side by side with complete guidelines.

Frequently Asked Questions

How do I order columns in a pivot table?

To order columns in a Pivot Table in Excel, you can follow these steps:

  1. Click anywhere within the Pivot Table to select it.
  2. In the PivotTable Fields, rearrange your fields to control the order.
  3. To change the order of columns, you can drag a field from the Columns area and drop it into a different position within the Columns area.
  4. You can also use the Column Labels area to rearrange fields to change the order of columns in your Pivot Table.

By reordering the fields within the Columns and Column Labels areas of your Pivot Table, you can control the sequence and arrangement of columns to best suit your data analysis and presentation needs.

How do I group multiple columns in a Pivot Table?

To group multiple columns in a Pivot Table in Excel, follow these steps:

  1. Click anywhere within the Pivot Table to select it.
  2. In the PivotTable Fields, hold down the CTRL key to select multiple columns to group.
  3. Right-click on one of the selected columns, and then choose Group from the context menu.
    Excel will create a new grouped field in your Pivot Table. You can then further customize the grouping by right-clicking the grouped field, choosing Group again, and specifying the grouping criteria, such as date ranges or custom categories.

Grouping multiple columns in a Pivot Table allows you to create a more organized and concise data summary for analysis and reporting.

5/5 - (1 vote)

Leave a Reply

Your email address will not be published. Required fields are marked *