pivot table from different sheets/tables

[lezawang]

Hi
I have 2 tables. I want to create a pivot table from it. I tried ALT+D+P but did not work. I watched a video and they said both tables have to have same # of columns!! but that is not the case with my me. What should I do? Thanks you


[TABLE="width: 300"]
<tbody>[TR]
[TD]name[/TD]
[TD]hired date[/TD]
[/TR]
[TR]
[TD]mary[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]john[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 300"]
<tbody>[TR]
[TD]name[/TD]
[TD]age[/TD]
[TD]gender[/TD]
[TD]dept[/TD]
[TD]city[/TD]
[/TR]
[TR]
[TD]mary[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]john[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]