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.

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.

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.
   

This will change your Pivot Table layout. It will show the Pivot Table columns side by side in Excel.

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.
   
3. Next, go to Display tab in the PivotTable Options dialog box.
4. Now, check on the Classic PivotTable layout and click OK.
   

As a result, this will update your Pivot Table columns side by side.

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.
   
3. Next, choose None in the Subtotals section in the PivotTable Field dialog box and click OK.
   
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.

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.