![]() Our goal to consolidate multiple worksheets into a pivot table.īad news: The Pivot Table Wizard is no available on the ribbon. OK, go to the Team1 worksheet and now we can open the tool named the Pivot Table Wizard. Team1, Team2, Team3 and Team4 tabs contain similar data. This data summarizes yearly sales for 4 years (from 2013 to 2016) the years are along the top and the row labels are along the side. In this case the Pivot table consolidation technique will not work.įurther information: We need to make sure that there are no blank cells anywhere in our data table. ![]() If we were to have Product in cell B2, and Year in cell C2, the data values would not be perfectly rectangular. Here comes a non-regtangular data sample. It’s very important that your data be in a perfect rectangle.
0 Comments
Leave a Reply. |