and this is the pivot table I am aiming for. I am using "visit month" here as per your suggestion as works to pick up the visitor numbers form the webstats table. New loads is a measure counting transactions in the transaction table. Registrations woudl be a count of User ID in Users table where Reg Month = Visitor month.
<table width="461" border="0" cellpadding="0" cellspacing="0"><colgroup><col style="mso-width-source:userset;mso-width-alt:4010;width:71pt" width="94"> <col style="mso-width-source:userset;mso-width-alt:2944;width:52pt" width="69"> <col style="width:42pt" width="56"> <col style="mso-width-source:userset;mso-width-alt:2645;width:47pt" width="62"> <col style="mso-width-source:userset;mso-width-alt:3584;width:63pt" width="84"> <col style="mso-width-source:userset;mso-width-alt:4096;width:72pt" width="96"> </colgroup><tbody><tr style="mso-height-source:userset;height:24.75pt" height="33"> <td class="xl157" style="height:24.75pt;width:71pt; font-size:10.0pt;color:white;font-weight:400;text-decoration:none;text-underline-style: none;text-line-through:none;font-family:"Arial Narrow";border-top:none; border-right:none;border-bottom:.5pt solid #DCE6F1;border-left:none; background:#366092;mso-pattern:#366092 none" height="33" width="94">Transaction Month</td> <td class="xl158" style="width:52pt;font-size:10.0pt;color:white; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Arial Narrow";border-top:none;border-right:none;border-bottom: .5pt solid #B8CCE4;border-left:none;background:#366092;mso-pattern:#366092 none" width="69">New Loads</td> <td class="xl158" style="width:42pt;font-size:10.0pt;color:white; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Arial Narrow";border-top:none;border-right:none;border-bottom: .5pt solid #B8CCE4;border-left:none;background:#366092;mso-pattern:#366092 none" width="56">New Visitors</td> <td class="xl158" style="width:47pt;font-size:10.0pt;color:white; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Arial Narrow";border-top:none;border-right:none;border-bottom: .5pt solid #B8CCE4;border-left:none;background:#366092;mso-pattern:#366092 none" width="62">New Load Conv%</td> <td class="xl157" style="width:63pt" width="84">Registrations</td> <td class="xl157" style="width:72pt" width="96">Conversion %</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl159" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Arial Narrow";border-top:.5pt solid #DCE6F1;border-right: none;border-bottom:.5pt solid #DCE6F1;border-left:none" height="17">January 2011</td> <td class="xl160" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Arial Narrow";border-top:.5pt solid #DCE6F1;border-right:.5pt solid #366092; border-bottom:.5pt solid #DCE6F1;border-left:.5pt solid #366092"> 24 </td> <td class="xl162" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Arial Narrow";border-top:.5pt solid #DCE6F1;border-right:none; border-bottom:.5pt solid #DCE6F1;border-left:none" align="right">16,298</td> <td class="xl163" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Arial Narrow";border-top:.5pt solid #DCE6F1;border-right:.5pt solid #366092; border-bottom:.5pt solid #DCE6F1;border-left:.5pt solid #366092" align="right">0.1 %</td> <td class="xl157" align="right">500</td> <td class="xl164" align="right">3%</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl159" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Arial Narrow";border-top:.5pt solid #DCE6F1;border-right: none;border-bottom:.5pt solid #DCE6F1;border-left:none" height="17">February 2011</td> <td class="xl160" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Arial Narrow";border-top:.5pt solid #DCE6F1;border-right:.5pt solid #366092; border-bottom:.5pt solid #DCE6F1;border-left:.5pt solid #366092"> 144 </td> <td class="xl162" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Arial Narrow";border-top:.5pt solid #DCE6F1;border-right:none; border-bottom:.5pt solid #DCE6F1;border-left:none" align="right">21,986</td> <td class="xl163" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Arial Narrow";border-top:.5pt solid #DCE6F1;border-right:.5pt solid #366092; border-bottom:.5pt solid #DCE6F1;border-left:.5pt solid #366092" align="right">0.7 %</td> <td class="xl157">
</td> <td class="xl157">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl159" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Arial Narrow";border-top:.5pt solid #DCE6F1;border-right: none;border-bottom:.5pt solid #DCE6F1;border-left:none" height="17">March 2011</td> <td class="xl160" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Arial Narrow";border-top:.5pt solid #DCE6F1;border-right:.5pt solid #366092; border-bottom:.5pt solid #DCE6F1;border-left:.5pt solid #366092"> 317 </td> <td class="xl162" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Arial Narrow";border-top:.5pt solid #DCE6F1;border-right:none; border-bottom:.5pt solid #DCE6F1;border-left:none" align="right">31,808</td> <td class="xl163" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Arial Narrow";border-top:.5pt solid #DCE6F1;border-right:.5pt solid #366092; border-bottom:.5pt solid #DCE6F1;border-left:.5pt solid #366092" align="right">1.0 %</td> <td class="xl157">
</td> <td class="xl157">
</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl159" style="height:12.75pt;font-size:10.0pt;color:black; font-weight:400;text-decoration:none;text-underline-style:none;text-line-through: none;font-family:"Arial Narrow";border-top:.5pt solid #DCE6F1;border-right: none;border-bottom:.5pt solid #DCE6F1;border-left:none" height="17">April 2011</td> <td class="xl160" style="font-size:10.0pt;color:black;font-weight:400; text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Arial Narrow";border-top:.5pt solid #DCE6F1;border-right:.5pt solid #366092; border-bottom:.5pt solid #DCE6F1;border-left:.5pt solid #366092"> 318 </td> <td class="xl162" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Arial Narrow";border-top:.5pt solid #DCE6F1;border-right:none; border-bottom:.5pt solid #DCE6F1;border-left:none" align="right">16,908</td> <td class="xl163" style="font-size:10.0pt;color:black;font-weight: 400;text-decoration:none;text-underline-style:none;text-line-through:none; font-family:"Arial Narrow";border-top:.5pt solid #DCE6F1;border-right:.5pt solid #366092; border-bottom:.5pt solid #DCE6F1;border-left:.5pt solid #366092" align="right">1.9 %</td> <td class="xl157">
</td> <td class="xl157">
</td> </tr> </tbody></table>
Hope I'm making more sense. Thnaks