Hello, I am trying to create a pivot table using data from multiple tabs but am having some issues. If anyone could assist it would be greatly appreciated. Here is the information:
I have multiple worksheets (on different days) with the same headers. For example, let's say each worksheet has a NAME column (additional names could be added on different dates), number of dogs column, number of cats column, and number of fish column.
I would like a pivot table
<tbody>
</tbody>
****** id="cke_pastebin" style="position: absolute; top: 159px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
<tbody>
</tbody>
I have multiple worksheets (on different days) with the same headers. For example, let's say each worksheet has a NAME column (additional names could be added on different dates), number of dogs column, number of cats column, and number of fish column.
I would like a pivot table
number of dogs | number of dogs | number of cats | number of cats | number of fish | number of fish | ||||
Name | 2017 (name of the worksheet) | 2016 (name of worksheet) | 2017 (name of the worksheet) | 2016 (name of worksheet) | 2017 (name of the worksheet) | 2016 (name of worksheet) | |||
A | |||||||||
B | |||||||||
C |
<tbody>
</tbody>
****** id="cke_pastebin" style="position: absolute; top: 159px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">
Name |
<tbody>
</tbody>
Last edited: