The real power of a PivotTable comes out when you want to rearrange your data dynamically.…A task that would take several minutes, at least, if done by hand, takes just a…few seconds when you want to summarize your data in a PivotTable.…In a PivotTable, the row and column headers provide the basic structure.…So, for example, here in the PivotTable, you'll see that I have my…company, FirmA and FirmB, my two companies, and then I also have my…months, January through December.…When you look over in the PivotTable Builder, you'll see that that structure is reflected here.…

So, for example, I have the Company field, which provides the values here: FirmA…and FirmB, have the Month, providing the values for the Row Labels, and then we…have the Values, which is sum of Revenue here in the middle.…Changing the position of the row and column headers in a PivotTable Builder…changes their organization within the PivotTable.…So let's say, for example, that I wanted to arrange my data first by Company and…