Should you work with plenty of information in Excel, you will typically have to create pivot tables to summarize and analyze your information. Nevertheless, one problem it’s possible you’ll face is separating columns in your pivot desk. By default, Excel will typically group columns collectively, which may make it troublesome to learn and perceive your information. Due to this fact, it is vital to know the right way to separate columns in your pivot desk if you wish to get essentially the most out of your information.
Thankfully, separating columns in a pivot desk is a comparatively easy course of. First, choose the pivot desk you wish to edit. Then, click on on the “Design” tab within the ribbon. Within the “Format” part of the ribbon, you will see a drop-down menu labeled “Present/Cover Fields.” Click on on this drop-down menu and choose the “Unhide Fields” choice. This can show a listing of all of the fields in your information supply. Discover the sphere that you simply wish to separate into a number of columns, then drag and drop it into the “Rows” or “Columns” part of the pivot desk. As soon as you’ve got added the sphere to the pivot desk, you should use the drop-down menu subsequent to the sphere title to pick the way you wish to show the information. You may select to point out the information as a single column, or you may separate it into a number of columns by deciding on the “Present Gadgets” choice.
Along with utilizing the “Present/Cover Fields” choice, you can too separate columns in a pivot desk by utilizing the “PivotTable Choices” dialog field. To open the “PivotTable Choices” dialog field, right-click on the pivot desk and choose the “PivotTable Choices” choice. Within the “PivotTable Choices” dialog field, click on on the “Format & Format” tab. Within the “Format” part of the tab, you will see a drop-down menu labeled “Present/Cover Fields.” Click on on this drop-down menu and choose the “Unhide Fields” choice. This can show a listing of all of the fields in your information supply. Discover the sphere that you simply wish to separate into a number of columns, then test the field subsequent to the sphere title. As soon as you’ve got checked the field, click on on the “OK” button to shut the “PivotTable Choices” dialog field. The sphere will now be added to the pivot desk as a separate column.
Learn how to Separate Columns in Excel Pivot Desk
A pivot desk is a strong device in Excel that means that you can summarize and analyze giant information units. One frequent activity when working with pivot tables is separating columns. This may be helpful for a wide range of causes, resembling:
- Making the pivot desk simpler to learn and perceive
- Creating a number of subtotals or grand totals
- Evaluating information from totally different views
There are two major methods to separate columns in an Excel pivot desk:
- Drag and drop the fields
- Use the “Ungroup” command
Drag and Drop the Fields
The most typical approach to separate columns in a pivot desk is to tug and drop the fields. To do that, observe these steps:
- Click on on the sphere that you simply wish to separate.
- Drag the sphere to the specified location within the pivot desk.
- Drop the sphere while you see the blue line indicating the place the sphere might be positioned.
For instance, in case you have a pivot desk that reveals gross sales by product and area, you may drag and drop the “Product” subject to the “Rows” space and the “Area” subject to the “Columns” space. This may create a pivot desk that reveals gross sales for every product in every area.
Use the “Ungroup” Command
When you have a subject that’s already grouped within the pivot desk, you may ungroup it to separate the columns. To do that, observe these steps:
- Proper-click on the grouped subject.
- Choose the “Ungroup” command from the menu.
For instance, in case you have a pivot desk that reveals gross sales by product and area, and the “Product” subject is grouped by class, you may ungroup the “Product” subject to point out gross sales for every particular person product.
After getting separated the columns in your pivot desk, you should use the opposite options of the pivot desk to additional analyze your information. For instance, you may add subtotals or grand totals, create calculated fields, and use slicers to filter the information.
Individuals Additionally Ask About Learn how to Separate Columns in Excel Pivot Desk
How do I separate a number of columns in an Excel pivot desk?
You may separate a number of columns in an Excel pivot desk by dragging and dropping the fields one after the other. Alternatively, you should use the “Ungroup” command to ungroup a number of fields directly.
How do I create a pivot desk with columns aspect by aspect?
To create a pivot desk with columns aspect by aspect, drag and drop the fields that you simply wish to show within the columns to the “Columns” space of the pivot desk.
How do I separate columns in a pivot desk with out dropping information?
Whenever you separate columns in a pivot desk, you’ll not lose any information. The info will merely be rearranged within the pivot desk.
