Multiple Consolidation Range Pivot Table Question

[Xceller]

I have a data set, range (“A1:CG4”) that is not in a list (Table) format that I would like to select some field columns within the range and perform a Multiple Consolidation Range Pivot Table.
The ranges I want to select are:
EmployeeNames (“B1:B5”)
VestingMonths (“AL1:CG5”)

Problem:
(1). The resulted pivot table omits the first column “AL1:AL5” in Red
I could shift 1 column to the left by selecting (“AK1:CG5”), but Why?

(2). The Row Labels in the resulted pivot table do not display Names from Column (“B1:B5”). Why?
Is it because there are multiple transactions ( 11/30/05….12/31/05….09/30/09) per Name? Can this be fixed.
Your help is greatly appreciated.

A B C D E F ........ AL AM ..........CG
EE# Name Date1 Date2 Status P-Shares 10/31/05 11/30/05 9/30/09
1 John 10/4/05 10/31/05 Active 30,000 $675.00 $675.00 $675.00
2 Mary 10/4/05 10/31/05 Active 45,000 $937.00 $937.00 $937.00
3 Kate 10/4/05 10/31/05 Active 25,000 $520.00 $520.00 $520.00
4 Jack 10/4/05 10/31/05 Active 3,000 $62.00 $62.00 $62.00

Pivot Table Result:
<table class="MsoNormalTable" style="width:276.0pt;margin-left:4.8pt;border-collapse:collapse;mso-yfti-tbllook: 1184;mso-padding-alt:0in 5.4pt 0in 5.4pt" border="0" cellpadding="0" cellspacing="0" width="460"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;height:13.2pt"> <td style="width:1.0in;border:none;border-bottom: solid #95B3D7 1.0pt;mso-border-bottom-alt:solid #95B3D7 .5pt;background:#DBE5F1; padding:0in 5.4pt 0in 5.4pt;height:13.2pt" nowrap="nowrap" valign="bottom" width="120"> [FONT=&quot]Page1[/FONT]
</td> <td style="width:88.0pt;border:none; border-bottom:solid #95B3D7 1.0pt;mso-border-bottom-alt:solid #95B3D7 .5pt; background:#DBE5F1;padding:0in 5.4pt 0in 5.4pt;height:13.2pt" nowrap="nowrap" valign="bottom" width="147"> [FONT=&quot](All)[/FONT]
</td> <td style="width:55.0pt;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="92">
</td> <td style="width:61.0pt;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="102">
</td> </tr> <tr style="mso-yfti-irow:1;height:13.2pt"> <td style="width:1.0in;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="120">
</td> <td style="width:88.0pt;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="147">
</td> <td style="width:55.0pt;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="92">
</td> <td style="width:61.0pt;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="102">
</td> </tr> <tr style="mso-yfti-irow:2;height:13.2pt"> <td style="width:1.0in;background:#DBE5F1; padding:0in 5.4pt 0in 5.4pt;height:13.2pt" nowrap="nowrap" valign="bottom" width="120"> [FONT=&quot]Sum of Value[/FONT]
</td> <td style="width:88.0pt;background:#DBE5F1; padding:0in 5.4pt 0in 5.4pt;height:13.2pt" nowrap="nowrap" valign="bottom" width="147"> [FONT=&quot]Column Labels[/FONT]
</td> <td style="width:55.0pt;background:#DBE5F1; padding:0in 5.4pt 0in 5.4pt;height:13.2pt" nowrap="nowrap" valign="bottom" width="92">
</td> <td style="width:61.0pt;background:#DBE5F1; padding:0in 5.4pt 0in 5.4pt;height:13.2pt" nowrap="nowrap" valign="bottom" width="102">
</td> </tr> <tr style="mso-yfti-irow:3;height:13.2pt"> <td style="width:1.0in;border:none;border-bottom: solid #95B3D7 1.0pt;mso-border-bottom-alt:solid #95B3D7 .5pt;background:#DBE5F1; padding:0in 5.4pt 0in 5.4pt;height:13.2pt" nowrap="nowrap" valign="bottom" width="120"> [FONT=&quot]Row Labels[/FONT]
</td> <td style="width:88.0pt;border:none; border-bottom:solid #95B3D7 1.0pt;mso-border-bottom-alt:solid #95B3D7 .5pt; background:#DBE5F1;padding:0in 5.4pt 0in 5.4pt;height:13.2pt" nowrap="nowrap" valign="bottom" width="147">

[FONT=&quot]11/30/2005[/FONT]​

</td> <td style="width:55.0pt;border:none;border-bottom: solid #95B3D7 1.0pt;mso-border-bottom-alt:solid #95B3D7 .5pt;background:#DBE5F1; padding:0in 5.4pt 0in 5.4pt;height:13.2pt" nowrap="nowrap" valign="bottom" width="92">

[FONT=&quot]12/31/2005[/FONT]​

</td> <td style="width:61.0pt;border:none; border-bottom:solid #95B3D7 1.0pt;mso-border-bottom-alt:solid #95B3D7 .5pt; background:#DBE5F1;padding:0in 5.4pt 0in 5.4pt;height:13.2pt" nowrap="nowrap" valign="bottom" width="102"> [FONT=&quot]Grand Total[/FONT]
</td> </tr> <tr style="mso-yfti-irow:4;height:13.2pt"> <td style="width:1.0in;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="120"> [FONT=&quot]62[/FONT]
</td> <td style="width:88.0pt;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="147"> [FONT=&quot] 62.00 [/FONT]
</td> <td style="width:55.0pt;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="92"> [FONT=&quot] 62.00 [/FONT]
</td> <td style="width:61.0pt;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="102"> [FONT=&quot] 2,938.00 [/FONT]
</td> </tr> <tr style="mso-yfti-irow:5;height:13.2pt"> <td style="width:1.0in;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="120"> [FONT=&quot]520[/FONT]
</td> <td style="width:88.0pt;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="147"> [FONT=&quot] 520.00 [/FONT]
</td> <td style="width:55.0pt;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="92"> [FONT=&quot] 521.00 [/FONT]
</td> <td style="width:61.0pt;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="102"> [FONT=&quot] 24,480.00 [/FONT]
</td> </tr> <tr style="mso-yfti-irow:6;height:13.2pt"> <td style="width:1.0in;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="120"> [FONT=&quot]625[/FONT]
</td> <td style="width:88.0pt;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="147"> [FONT=&quot] 625.00 [/FONT]
</td> <td style="width:55.0pt;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="92"> [FONT=&quot] 625.00 [/FONT]
</td> <td style="width:61.0pt;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="102"> [FONT=&quot] 29,375.00 [/FONT]
</td> </tr> <tr style="mso-yfti-irow:7;height:13.2pt"> <td style="width:1.0in;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="120"> [FONT=&quot]937[/FONT]
</td> <td style="width:88.0pt;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="147"> [FONT=&quot] 937.00 [/FONT]
</td> <td style="width:55.0pt;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="92"> [FONT=&quot] 937.00 [/FONT]
</td> <td style="width:61.0pt;padding:0in 5.4pt 0in 5.4pt; height:13.2pt" nowrap="nowrap" valign="bottom" width="102"> [FONT=&quot] 44,063.00 [/FONT]
</td> </tr> <tr style="mso-yfti-irow:8;mso-yfti-lastrow:yes;height:13.2pt"> <td style="width:1.0in;border:none;border-top: solid #95B3D7 1.0pt;mso-border-top-alt:solid #95B3D7 .5pt;background:#DBE5F1; padding:0in 5.4pt 0in 5.4pt;height:13.2pt" nowrap="nowrap" valign="bottom" width="120"> [FONT=&quot]Grand Total[/FONT]
</td> <td style="width:88.0pt;border:none; border-top:solid #95B3D7 1.0pt;mso-border-top-alt:solid #95B3D7 .5pt; background:#DBE5F1;padding:0in 5.4pt 0in 5.4pt;height:13.2pt" nowrap="nowrap" valign="bottom" width="147"> [FONT=&quot] 2,144.00 [/FONT]
</td> <td style="width:55.0pt;border:none;border-top: solid #95B3D7 1.0pt;mso-border-top-alt:solid #95B3D7 .5pt;background:#DBE5F1; padding:0in 5.4pt 0in 5.4pt;height:13.2pt" nowrap="nowrap" valign="bottom" width="92"> [FONT=&quot] 2,145.00 [/FONT]
</td> <td style="width:61.0pt;border:none; border-top:solid #95B3D7 1.0pt;mso-border-top-alt:solid #95B3D7 .5pt; background:#DBE5F1;padding:0in 5.4pt 0in 5.4pt;height:13.2pt" nowrap="nowrap" valign="bottom" width="102"> [FONT=&quot] 100,856.00 [/FONT]
</td> </tr> </tbody></table>

 

[GlennUK]

duplicate post:

http://www.mrexcel.com/forum/showthread.php?t=538035