astroinhouston
New Member
- Joined
- Nov 17, 2008
- Messages
- 4
I need help on a finding out how to create a reporting format. I have data similarly to what is gathered below in columns A-F rows1-6, but the actual worksheet I am making the report from has 104 rows through column CN.
<o> </o>
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->
<table class="MsoNormalTable" style="width: 273pt; margin-left: 4.7pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="364"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" valign="bottom" width="68" nowrap="nowrap"> </td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 27pt; height: 12.75pt;" valign="bottom" width="36" nowrap="nowrap"> </td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 58pt; height: 12.75pt;" valign="bottom" width="77" nowrap="nowrap"> </td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 63pt; height: 12.75pt;" valign="bottom" width="84" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" valign="bottom" width="68" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 27pt; height: 12.75pt;" valign="bottom" width="36" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 58pt; height: 12.75pt;" valign="bottom" width="77" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 63pt; height: 12.75pt;" valign="bottom" width="84" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" valign="bottom" width="68" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 27pt; height: 12.75pt;" valign="bottom" width="36" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 58pt; height: 12.75pt;" valign="bottom" width="77" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 63pt; height: 12.75pt;" valign="bottom" width="84" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" valign="bottom" width="68" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 27pt; height: 12.75pt;" valign="bottom" width="36" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 58pt; height: 12.75pt;" valign="bottom" width="77" nowrap="nowrap">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 63pt; height: 12.75pt;" valign="bottom" width="84" nowrap="nowrap">
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" valign="bottom" width="68" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 27pt; height: 12.75pt;" valign="bottom" width="36" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap">
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 58pt; height: 12.75pt;" valign="bottom" width="77" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 63pt; height: 12.75pt;" valign="bottom" width="84" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" valign="bottom" width="68" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 27pt; height: 12.75pt;" valign="bottom" width="36" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 58pt; height: 12.75pt;" valign="bottom" width="77" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 63pt; height: 12.75pt;" valign="bottom" width="84" nowrap="nowrap"> </td> </tr> </tbody></table>
I need to be able to create a report that lists all fields with M, C, or UC but I need to get it to list the customer# multiple times, as below...
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->
<table class="MsoNormalTable" style="width: 181pt; margin-left: 4.7pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="241"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" valign="bottom" width="68" nowrap="nowrap"> </td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 27pt; height: 12.75pt;" valign="bottom" width="36" nowrap="nowrap"> </td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 66pt; height: 12.75pt;" valign="bottom" width="88" nowrap="nowrap"> </td> <td style="border-style: solid solid solid none; border-color: windowtext windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" x:num="" valign="bottom" width="68" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 27pt; height: 12.75pt;" valign="bottom" width="36" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66pt; height: 12.75pt;" valign="bottom" width="88" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" x:num="" valign="bottom" width="68" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 27pt; height: 12.75pt;" valign="bottom" width="36" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66pt; height: 12.75pt;" valign="bottom" width="88" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" x:num="" valign="bottom" width="68" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 27pt; height: 12.75pt;" valign="bottom" width="36" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66pt; height: 12.75pt;" x:str="personaldoc1 " valign="bottom" width="88" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" x:num="" valign="bottom" width="68" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 27pt; height: 12.75pt;" valign="bottom" width="36" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66pt; height: 12.75pt;" valign="bottom" width="88" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" x:num="" valign="bottom" width="68" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 27pt; height: 12.75pt;" valign="bottom" width="36" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66pt; height: 12.75pt;" x:str="waiver1 " valign="bottom" width="88" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" x:num="" valign="bottom" width="68" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 27pt; height: 12.75pt;" valign="bottom" width="36" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66pt; height: 12.75pt;" valign="bottom" width="88" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" x:num="" valign="bottom" width="68" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 27pt; height: 12.75pt;" valign="bottom" width="36" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66pt; height: 12.75pt;" valign="bottom" width="88" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" x:num="" valign="bottom" width="68" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 27pt; height: 12.75pt;" valign="bottom" width="36" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66pt; height: 12.75pt;" x:str="personaldoc1 " valign="bottom" width="88" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" x:num="" valign="bottom" width="68" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 27pt; height: 12.75pt;" valign="bottom" width="36" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66pt; height: 12.75pt;" valign="bottom" width="88" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" x:num="" valign="bottom" width="68" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 27pt; height: 12.75pt;" valign="bottom" width="36" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66pt; height: 12.75pt;" x:str="personaldoc1 " valign="bottom" width="88" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" x:num="" valign="bottom" width="68" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 27pt; height: 12.75pt;" valign="bottom" width="36" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 66pt; height: 12.75pt;" valign="bottom" width="88" nowrap="nowrap"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap"> </td> </tr> </tbody></table>
If the column from the first table did not apply it is left blank, and I do not need to report blanks or anything with O or RO, and ideally this would be a list on a new worksheet within the workbook and not a pivot table.
I am attempting to do this on 2003 excel(laptop) I do have 2007 on my office PC if that would be a better option.
Thank you for any and all help.
<o> </o>
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->
<table class="MsoNormalTable" style="width: 273pt; margin-left: 4.7pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="364"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" valign="bottom" width="68" nowrap="nowrap">
customer#<o></o>
state<o></o>
waiver1<o></o>
waiver2<o></o>
personaloc1<o></o>
personaldoc2<o></o>
1001<o></o>
TX<o></o>
M<o></o>
<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 58pt; height: 12.75pt;" valign="bottom" width="77" nowrap="nowrap">
RO<o></o>
UC<o></o>
1002<o></o>
MD<o></o>
<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 37pt; height: 12.75pt;" valign="bottom" width="49" nowrap="nowrap">
O<o></o>
M<o></o>
M<o></o>
1003<o></o>
FL<o></o>
UC<o></o>
C<o></o>
<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 63pt; height: 12.75pt;" valign="bottom" width="84" nowrap="nowrap">
<o></o>
</td> </tr> <tr style="height: 12.75pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" valign="bottom" width="68" nowrap="nowrap">
1004<o></o>
NV<o></o>
UC<o></o>
<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0in 5.4pt; width: 58pt; height: 12.75pt;" valign="bottom" width="77" nowrap="nowrap">
C<o></o>
RO<o></o>
1005<o></o>
OK<o></o>
M<o></o>
O<o></o>
UC<o></o>
C<o></o>
I need to be able to create a report that lists all fields with M, C, or UC but I need to get it to list the customer# multiple times, as below...
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->
<table class="MsoNormalTable" style="width: 181pt; margin-left: 4.7pt; border-collapse: collapse;" border="0" cellpadding="0" cellspacing="0" width="241"> <tbody><tr style="height: 12.75pt;"> <td style="border: 1pt solid windowtext; padding: 0in 5.4pt; width: 51pt; height: 12.75pt;" valign="bottom" width="68" nowrap="nowrap">
customer#<o></o>
state<o></o>
document<o></o>
status<o></o>
1001<o></o>
TX<o></o>
waiver1<o></o>
M<o></o>
1001<o></o>
TX<o></o>
personaldoc2<o></o>
UC<o></o>
1002<o></o>
MD<o></o>
personaldoc1 <o></o>
M<o></o>
1002<o></o>
MD<o></o>
personaldoc2<o></o>
M<o></o>
1003<o></o>
FL<o></o>
waiver1 <o></o>
UC<o></o>
1003<o></o>
FL<o></o>
waiver2<o></o>
C<o></o>
1004<o></o>
NV<o></o>
waiver1<o></o>
UC<o></o>
1004<o></o>
NV<o></o>
personaldoc1 <o></o>
C<o></o>
1005<o></o>
OK<o></o>
waiver1<o></o>
M<o></o>
1005<o></o>
OK<o></o>
personaldoc1 <o></o>
UC<o></o>
1005<o></o>
OK<o></o>
personaldoc2<o></o>
C<o></o>
If the column from the first table did not apply it is left blank, and I do not need to report blanks or anything with O or RO, and ideally this would be a list on a new worksheet within the workbook and not a pivot table.
I am attempting to do this on 2003 excel(laptop) I do have 2007 on my office PC if that would be a better option.
Thank you for any and all help.