![how do i use pivot tables in excel 2013 how do i use pivot tables in excel 2013](https://i.ytimg.com/vi/xm8U8DS8nP4/maxresdefault.jpg)
Remove the City field from the pivot table, and add the CityName field to replace it. STEP 1: Select a cell in your table STEP 2: Let us insert our table To do that press Ctrl + T or go to Insert > Table: STEP 3: Click OK.If the source data is stored in an Excel Table, the formula should copy down automatically. Copy the formula down to the last row of data in the source table.
![how do i use pivot tables in excel 2013 how do i use pivot tables in excel 2013](https://exceljet.net/sites/default/files/images/articles/inline/perfect_data.png)
In Row 2 of the new column, enter the formula =TRIM(C2).Step 2: Use your mouse to highlight all of the data that you want to include in the pivot table.