Multiple Consolidation Range Pivot Table Problem

[Xceller]

I have a dataset, range (“C5:C3131”) that is not in a list (Table) format that I would like to select some fields ( columns) within the sheet and perform a Multiple Consolidation Range Pivot Table.

The ranges I want to select are:
EmployeeNames (“C5:C3131”)
VestingMonths (“AN5:AN3131”)

Problem:
(1). The resulted pivot table omits the first column “AN5:AN3131”. It only includes Range ("AO5:AN3131")

I could shift 1 column by selecting (“AM5:AN3131”), but Why does it do that?

(2). The EmployeeName column (“C5:C3131”) does not display any names but just numbers instead. Why?

Is it because there are duplicate names? How do I get the employee name to appear instead of numbers?

Your help is greatly appreciated.

 

[GlennUK]

Can you describe what you are trying to achieve, please?

 

[Xceller]

<table border="0" cellpadding="0" cellspacing="0" width="357"><col style="mso-width-source:userset;mso-width-alt:1393; width:29pt" span="2" width="39"> <col style="mso-width-source:userset;mso-width-alt:1621;width:34pt" width="46"> <col style="mso-width-source:userset;mso-width-alt:2190;width:46pt" width="62"> <col style="mso-width-source:userset;mso-width-alt:1735;width:37pt" width="49"> <col style="mso-width-source:userset;mso-width-alt:2048;width:43pt" width="58"> <col style="mso-outline-parent:collapsed;width:48pt" width="64"> <tbody><tr style="height:30.6pt" height="41"> <td class="xl78" style="height:30.6pt;width:29pt" height="41" width="39">EmplNo</td> <td class="xl79" style="width:29pt" width="39">Name</td> <td class="xl80" style="width:34pt" width="46">
Grant
Date</td> <td class="xl80" style="width:46pt" width="62">Actual
Vesting
StartMonth</td> <td class="xl80" style="width:37pt" width="49">Empl
Status</td> <td class="xl81" style="width:43pt" width="58">P
Shares</td> <td class="xl84" style="width:48pt" align="right" width="64">10/31/05</td> </tr> <tr style="height:10.2pt" height="14"> <td class="xl63" style="height:10.2pt" align="right" height="14">1</td> <td class="xl65">John</td> <td class="xl68" align="right">10/04/05</td> <td class="xl66" align="right">10/31/05</td> <td class="xl65">Active</td> <td class="xl69"> 30,000.00 </td> <td class="xl75"> 625.00 </td> </tr> <tr style="height:10.2pt" height="14"> <td class="xl63" style="height:10.2pt" align="right" height="14">2</td> <td class="xl65">Mary</td> <td class="xl68" align="right">10/04/05</td> <td class="xl66" align="right">10/31/05</td> <td class="xl65">Active</td> <td class="xl69"> 45,000.00 </td> <td class="xl75"> 937.00 </td> </tr> <tr style="height:10.2pt" height="14"> <td class="xl63" style="height:10.2pt" align="right" height="14">3</td> <td class="xl65">Kate</td> <td class="xl68" align="right">10/04/05</td> <td class="xl66" align="right">10/31/05</td> <td class="xl65">Active</td> <td class="xl69"> 25,000.00 </td> <td class="xl75"> 520.00 </td> </tr> <tr style="height:10.2pt" height="14"> <td class="xl63" style="height:10.2pt" align="right" height="14">4</td> <td class="xl65">George</td> <td class="xl68" align="right">10/04/05</td> <td class="xl66" align="right">10/31/05</td> <td class="xl65">Active</td> <td class="xl69"> 3,000.00 </td> <td class="xl75"> 62.00 </td> </tr> </tbody></table>

 

[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]

Can you show what you would like the pivottable to be?