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 [TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]number of dogs[/TD]
[TD]number of dogs[/TD]
[TD]number of cats[/TD]
[TD]number of cats[/TD]
[TD]number of fish[/TD]
[TD]number of fish[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]2017 (name of the worksheet)[/TD]
[TD]2016 (name of worksheet)[/TD]
[TD]2017 (name of the worksheet)[/TD]
[TD] 2016 (name of worksheet)[/TD]
[TD]2017 (name of the worksheet)[/TD]
[TD]2016 (name of worksheet)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
****** id="cke_pastebin" style="position: absolute; top: 159px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[/TR]
</tbody>[/TABLE]
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 [TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]number of dogs[/TD]
[TD]number of dogs[/TD]
[TD]number of cats[/TD]
[TD]number of cats[/TD]
[TD]number of fish[/TD]
[TD]number of fish[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Name[/TD]
[TD]2017 (name of the worksheet)[/TD]
[TD]2016 (name of worksheet)[/TD]
[TD]2017 (name of the worksheet)[/TD]
[TD] 2016 (name of worksheet)[/TD]
[TD]2017 (name of the worksheet)[/TD]
[TD]2016 (name of worksheet)[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
****** id="cke_pastebin" style="position: absolute; top: 159px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[/TR]
</tbody>[/TABLE]
Last edited: