MGMT
You can make this one table with all 3 columns at the same time.
Here's an easy? step-by-step recipe:
1) Select all the data on tab Pivot Table Data.
2) Click button Pivot Table on tab Insert
Did you find that button?
3) The Create PivotTable window pops up.
4) Click OK to select the defaults
5) PivotTable Fields pane opens on your spreadsheet. In PivotTable Fields, see the unchecked boxes for Movie Rank, Domestic Gross, Rating, and Type.
6) Click and drag Type to areas Rows and to Σ Values
7) Click and drag Domestic Gross to Σ Values
The finished table looks like