![]() ![]() To convert this pivot table to an ordinary data table, simply select the entire pivot table (in this case, we select the range E1:I6) and press Ctrl+C to copy the data. ![]() The pivot table will automatically be populated with the following values: ![]() Once you click OK, a new PivotTable Fields panel will appear on the right side of the screen.ĭrag the Store field to the Rows box, then drag the Product field to the Columns box, then drag the Quantity field to the Values box: In the new window that appears, choose A1:C16 as the range and choose to place the pivot table in cell E1 of the existing worksheet: To create a pivot table, click the Insert tab along the top ribbon and then click the PivotTable icon: Step 1: Enter the Dataįirst, let’s enter the following sales data for three different stores: The following step-by-step example shows how to convert an Excel pivot table to a data table. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |