Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Step 1: Select All > click "Auto Filter" > tick "P" > Copy

Image Added

Step 2: Paste in "Sheet 2", then "Delete" row 1 for C header

Image Added

Step 3: Select All > Clcik "Insert" menu > "Pivot Table" > place in new worksheet

Image Added

Step 4: 

Image Added