Remove blank in pivot table without pivot filter

lincolnho

Board Regular
Joined
May 12, 2011
Messages
63
Hello,

I have a pivot table issue with blank columns and rows in my pivot table. How can I remove this WITHOUT the filter in the pivot table?
the "-" indicate a completely blank cell. As you see, the column header and rows are blank.


<TABLE style="WIDTH: 431pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=574 border=0><COLGROUP><COL style="WIDTH: 220pt; mso-width-source: userset; mso-width-alt: 10715" width=293><COL style="WIDTH: 93pt; mso-width-source: userset; mso-width-alt: 4534" width=124><COL style="WIDTH: 118pt; mso-width-source: userset; mso-width-alt: 5741" width=157><TBODY><TR style="HEIGHT: 12.75pt" height=17><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: white; BORDER-LEFT: #ece9d8; WIDTH: 220pt; COLOR: #7030a0; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=293 height=17>Row Labels</TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: white; BORDER-LEFT: #ece9d8; WIDTH: 93pt; COLOR: #7030a0; BORDER-BOTTOM: #c2d69a 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=124>- </TD><TD style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: white; BORDER-LEFT: #ece9d8; WIDTH: 118pt; COLOR: #7030a0; BORDER-BOTTOM: #c2d69a 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=157>Discussion of Concern</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl68 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #7030a0; BORDER-LEFT: #ece9d8; COLOR: white; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #7030A0 none" height=17></TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #7030a0; BORDER-LEFT: #ece9d8; COLOR: white; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #7030A0 none"></TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #7030a0; BORDER-LEFT: #ece9d8; COLOR: white; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #7030A0 none"></TD></TR><TR style="HEIGHT: 12.75pt; mso-height-source: userset" height=17><TD class=xl69 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: white; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" height=17>-</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: white; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none"></TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: white; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: #eaf1dd; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" height=17>-</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: #eaf1dd; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none"></TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: #eaf1dd; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl71 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: #eaf1dd; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" height=17>-</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: #eaf1dd; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none"></TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: #eaf1dd; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl68 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #7030a0; BORDER-LEFT: #ece9d8; COLOR: white; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #7030A0 none" height=17>Steven MacLean</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #7030a0; BORDER-LEFT: #ece9d8; COLOR: white; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #7030A0 none"></TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #7030a0; BORDER-LEFT: #ece9d8; COLOR: white; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #7030A0 none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl69 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: white; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" height=17>Julie Payette</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: white; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none"></TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: white; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: #eaf1dd; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" height=17>Chris Hadfield</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: #eaf1dd; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none"></TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: #eaf1dd; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl71 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: #eaf1dd; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" height=17>inappropriate customer interaction</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: #eaf1dd; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none"></TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: #eaf1dd; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" align=right>16-May-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl68 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #7030a0; BORDER-LEFT: #ece9d8; COLOR: white; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #7030A0 none" height=17>Marc Garneau</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #7030a0; BORDER-LEFT: #ece9d8; COLOR: white; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #7030A0 none"></TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #7030a0; BORDER-LEFT: #ece9d8; COLOR: white; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #7030A0 none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl69 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: white; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" height=17>Roberta Bondar</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: white; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none"></TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: white; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl70 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: #eaf1dd; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" height=17>Robert Thirsk</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: #eaf1dd; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none"></TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: #eaf1dd; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl71 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: #eaf1dd; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" height=17>misconduct</TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: #eaf1dd; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none"></TD><TD class=xl67 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: #9bbb59; BORDER-LEFT: #ece9d8; COLOR: #eaf1dd; BORDER-BOTTOM: #ece9d8; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: #9BBB59 none" align=right>20-May-11</TD></TR></TBODY></TABLE>


I grab the data from

<TABLE style="WIDTH: 492pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=655 border=0><COLGROUP><COL style="WIDTH: 93pt; mso-width-source: userset; mso-width-alt: 4534" width=124><COL style="WIDTH: 73pt; mso-width-source: userset; mso-width-alt: 3547" width=97><COL style="WIDTH: 87pt; mso-width-source: userset; mso-width-alt: 4242" width=116><COL style="WIDTH: 85pt; mso-width-source: userset; mso-width-alt: 4132" width=113><COL style="WIDTH: 103pt; mso-width-source: userset; mso-width-alt: 5010" width=137><COL style="WIDTH: 51pt; mso-width-source: userset; mso-width-alt: 2486" width=68><TBODY><TR style="HEIGHT: 13.5pt" height=18><TD class=xl67 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: black; BORDER-LEFT: #ece9d8; WIDTH: 93pt; COLOR: white; BORDER-BOTTOM: white 1pt solid; FONT-FAMILY: Arial; HEIGHT: 13.5pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=124 height=18>Ops Manager</TD><TD class=xl67 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: black; BORDER-LEFT: #ece9d8; WIDTH: 73pt; COLOR: white; BORDER-BOTTOM: white 1pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=97>Manager</TD><TD class=xl67 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: black; BORDER-LEFT: #ece9d8; WIDTH: 87pt; COLOR: white; BORDER-BOTTOM: white 1pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=116>Agent</TD><TD class=xl67 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: black; BORDER-LEFT: #ece9d8; WIDTH: 85pt; COLOR: white; BORDER-BOTTOM: white 1pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=113>Topic</TD><TD class=xl67 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: black; BORDER-LEFT: #ece9d8; WIDTH: 103pt; COLOR: white; BORDER-BOTTOM: white 1pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=137>Action</TD><TD class=xl68 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 700; FONT-SIZE: 10pt; BACKGROUND: black; BORDER-LEFT: #ece9d8; WIDTH: 51pt; COLOR: white; BORDER-BOTTOM: white 1pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" width=68>Date</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" height=17>Steven MacLean</TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none">Julie Payette</TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none">Chris Hadfield</TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none">inappropriate customer interaction</TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none">Discussion of Concern</TD><TD class=xl69 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" align=right>16-May-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" height=17>Marc Garneau</TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none">Roberta Bondar</TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none">Robert Thirsk</TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none">misconduct</TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none">Discussion of Concern</TD><TD class=xl69 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" align=right>20-May-11</TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" height=17></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" height=17></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" height=17></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" height=17></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD></TR><TR style="HEIGHT: 12.75pt" height=17><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; HEIGHT: 12.75pt; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none" height=17></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: white 0.5pt solid; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD><TD class=xl69 style="BORDER-RIGHT: #ece9d8; BORDER-TOP: #ece9d8; FONT-WEIGHT: 400; FONT-SIZE: 10pt; BACKGROUND: yellow; BORDER-LEFT: #ece9d8; COLOR: windowtext; BORDER-BOTTOM: white 0.5pt solid; FONT-FAMILY: Arial; TEXT-DECORATION: none; text-underline-style: none; text-line-through: none; mso-pattern: black none"></TD></TR></TBODY></TABLE>
 
Last edited:

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,243
Is it that you are including blank rows in the source data? And if so, why are you doing that?
 

Forum statistics

Threads
1,082,257
Messages
5,364,074
Members
400,778
Latest member
Canadian Sal

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top