Is there a faster way to combine all the P.O# with a formula automatically, no matter how many P.O# there are? Its unpredictable on how many invoices will get pay per wire.
<table x:str="" style="border-collapse: collapse; width: 179pt;" width="239" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <col style="width: 56pt;" width="75"> <col style="width: 75pt;" width="100"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; width: 48pt;" width="64" height="17">Log #</td> <td class="xl25" style="width: 56pt;" width="75">Amount</td> <td class="xl27" style="width: 75pt;" width="100">P.O. Numbers</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">1-a</td> <td class="xl28" x:num="45678.484426309748">45,678 </td> <td class="xl26" x:num="">1234</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">1-b</td> <td class="xl28" x:num="89172.527116200319">89,173 </td> <td class="xl26" x:num="">5678</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">1-c</td> <td class="xl28" x:num="66525.851809145388">66,526 </td> <td class="xl26" x:num="">9123</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="" height="17">2</td> <td class="xl28" x:num="22112.903166205822">22,113 </td> <td class="xl26" x:num="">2345</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">3-a</td> <td class="xl28" x:num="66653.579134719723">66,654 </td> <td class="xl26" x:num="">6789</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">3-b</td> <td class="xl28" x:num="88650.086395522914">88,650 </td> <td class="xl26" x:num="">2468</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl26">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl26">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl26">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="" height="17">1</td> <td class="xl29" x:num="201376.86335165545">201,377 </td> <td class="xl26">1234/5678/9123</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="" height="17">2</td> <td class="xl29" x:num="22112.903166205822">22,113 </td> <td class="xl26" x:num="">2345</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="" height="17">3</td> <td class="xl29" x:num="155303.66553024264">155,304 </td> <td class="xl26">6789/2468</td> </tr> </tbody></table>
<table x:str="" style="border-collapse: collapse; width: 179pt;" width="239" border="0" cellpadding="0" cellspacing="0"><col style="width: 48pt;" width="64"> <col style="width: 56pt;" width="75"> <col style="width: 75pt;" width="100"> <tbody><tr style="height: 12.75pt;" height="17"> <td class="xl25" style="height: 12.75pt; width: 48pt;" width="64" height="17">Log #</td> <td class="xl25" style="width: 56pt;" width="75">Amount</td> <td class="xl27" style="width: 75pt;" width="100">P.O. Numbers</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">1-a</td> <td class="xl28" x:num="45678.484426309748">45,678 </td> <td class="xl26" x:num="">1234</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">1-b</td> <td class="xl28" x:num="89172.527116200319">89,173 </td> <td class="xl26" x:num="">5678</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">1-c</td> <td class="xl28" x:num="66525.851809145388">66,526 </td> <td class="xl26" x:num="">9123</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="" height="17">2</td> <td class="xl28" x:num="22112.903166205822">22,113 </td> <td class="xl26" x:num="">2345</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">3-a</td> <td class="xl28" x:num="66653.579134719723">66,654 </td> <td class="xl26" x:num="">6789</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" height="17">3-b</td> <td class="xl28" x:num="88650.086395522914">88,650 </td> <td class="xl26" x:num="">2468</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl26">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl26">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td style="height: 12.75pt;" height="17">
</td> <td class="xl29">
</td> <td class="xl26">
</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="" height="17">1</td> <td class="xl29" x:num="201376.86335165545">201,377 </td> <td class="xl26">1234/5678/9123</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="" height="17">2</td> <td class="xl29" x:num="22112.903166205822">22,113 </td> <td class="xl26" x:num="">2345</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl24" style="height: 12.75pt;" x:num="" height="17">3</td> <td class="xl29" x:num="155303.66553024264">155,304 </td> <td class="xl26">6789/2468</td> </tr> </tbody></table>