![]() Select the page field as “1” below the “All ranges” option.Then, click “Add.” Now, it will add the two tables to a single table. In that, select the range of table 1, click the “Add” button, and select the range of another table in another sheet.In this step, it will open another step after clicking the “Next” button as shown below. The window also will be moved to the third step. After selecting the above options, click on “Next” again.In that, select “I will create the page fields” as in the below dialog box. After clicking “Next,” it will go to Step2.Select “Multiple consolidation ranges” in that dialog box and click “Next.”. ![]() First, click “Alt+D,” then click “P.” The following dialog box will appear.Below are the steps to create a PivotTable from multiple sheets:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |