Pivot Tables are often used to rework data to get it into a normalised format and then use the resultant report as a source for another report, by copying and pasting the data into a new sheet. The problem is that with a typical pivot report, you then need to fill in the gaps and delete the unnecessary subtotals.
This lesson shows how you can set up the report so that this is done for you in the Pivot Report. You learn the various ways to use your Pivot Report as a normalized source for other processes. You are shown how to get an extract that makes up the report, fill in the gaps in the row, remove all subtotals and how to remove the Grand Totals.
To see the full course contents click here.