The basic requirement of creating a pivot table is that you must have a raw database that's been organized in columns within a worksheet, with each column having its own header. Select the data range. Go to Insert > Pivot table.
In the Create pivot table dialogue box, specify where you'd like to insert the pivot table, and then click on the Create button.