You can create as below for creating pivot in separate sheet.
If you want to create in the same sheet, then you can choose Destination as below. N2 can be replaced with the cell number in which you want to create the pivot.
You can create as below for creating pivot in separate sheet.
If you want to create in the same sheet, then you can choose Destination as below. N2 can be replaced with the cell number in which you want to create the pivot.