Is there anyone who can sort information in an infinite number of columns and an infinite number of rows by information contained in each row? Some rows will contain only one column and others will have several columns.
Additionally, after the sort, I would like to total the number of like rows and insert that total in column "A" in the front of the rows, deleting all but one of the like rows. Also, there is data in parentheses that I would like to add together, per row and insert the sum in column "B" at the front of the row.
I have attached before and after files.
Thanks for any help. I have spent a lot of time trying to figure this out, but I'm not savvy enough to do it. And if I didn't explain this well enough, I'll try to clarify.
Before sort:
****** http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8"><title></title>****** name="GENERATOR" content="OpenOffice.org 3.1 (Win32)"><style> <!-- BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Arial"; font-size:x-small } --> </style> <table border="0" cellspacing="0" cols="6" frame="VOID" rules="NONE"> <colgroup><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"></colgroup> <tbody> <tr> <td width="86" align="LEFT" height="17">102249(2)</td> <td width="86" align="LEFT">102250(2)</td> <td width="86" align="LEFT">102445(1)</td> <td width="86" align="LEFT">102251(2)</td> <td width="86" align="LEFT">
</td> <td width="86" align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102131(2)</td> <td align="LEFT">102442(1)</td> <td align="LEFT">102445(1)</td> <td align="LEFT">102252(1)</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102249(1)</td> <td align="LEFT">102250(1)</td> <td align="LEFT">102131(2)</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102120(1)</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102131(2)</td> <td align="LEFT">101773(1)</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102120(1)</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102251(2)</td> <td align="LEFT">102252(2)</td> <td align="LEFT">102442(1)</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102120(1)</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102251(1)</td> <td align="LEFT">102252(1)</td> <td align="LEFT">102250(1)</td> <td align="LEFT">102249(1)</td> <td align="LEFT">101890(1)</td> <td align="LEFT">101891(1)</td> </tr> <tr> <td align="LEFT" height="17">102249(3)</td> <td align="LEFT">102251(1)</td> <td align="LEFT">102445(1)</td> <td align="LEFT">102250(1)</td> <td align="LEFT">102253(1)</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102249(3)</td> <td align="LEFT">102445(1)</td> <td align="LEFT">102253(1)</td> <td align="LEFT">102251(1)</td> <td align="LEFT">102250(1)</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102249(1)</td> <td align="LEFT">102131(2)</td> <td align="LEFT">102250(1)</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102250(2)</td> <td align="LEFT">102251(2)</td> <td align="LEFT">102445(1)</td> <td align="LEFT">102249(1)</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> </tbody> </table>
After sort:
****** http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8"><title></title>****** name="GENERATOR" content="OpenOffice.org 3.1 (Win32)"><style> <!-- BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Arial"; font-size:x-small } --> </style> <table border="0" cellspacing="0" cols="8" frame="VOID" rules="NONE"> <colgroup><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"></colgroup> <tbody> <tr> <td sdval="1" sdnum="1033;" width="86" align="CENTER" height="17">1</td> <td sdval="3" sdnum="1033;" width="86" align="CENTER">3</td> <td width="86" align="LEFT">101773(1)</td> <td width="86" align="LEFT">102131(2)</td> <td width="86" align="CENTER">
</td> <td width="86" align="CENTER">
</td> <td width="86" align="LEFT">
</td> <td width="86" align="LEFT">
</td> </tr> <tr> <td sdval="1" sdnum="1033;" align="CENTER" height="17">1</td> <td sdval="6" sdnum="1033;" align="CENTER">6</td> <td align="LEFT">101890(1)</td> <td align="LEFT">101891(1)</td> <td align="LEFT">102249(1)</td> <td align="LEFT">102250(1)</td> <td align="LEFT">102251(1)</td> <td align="LEFT">102252(1)</td> </tr> <tr> <td sdval="3" sdnum="1033;" align="CENTER" height="17">3</td> <td sdval="1" sdnum="1033;" align="CENTER">1</td> <td align="LEFT">102120(1)</td> <td align="CENTER">
</td> <td align="CENTER">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td sdval="2" sdnum="1033;" align="CENTER" height="17">2</td> <td sdval="4" sdnum="1033;" align="CENTER">4</td> <td align="LEFT">102131(2)</td> <td align="LEFT">102249(1)</td> <td align="LEFT">102250(1)</td> <td align="CENTER">
</td> <td align="CENTER">
</td> <td align="LEFT">
</td> </tr> <tr> <td sdval="1" sdnum="1033;" align="CENTER" height="17">1</td> <td sdval="5" sdnum="1033;" align="CENTER">5</td> <td align="LEFT">102131(2)</td> <td align="LEFT">102252(1)</td> <td align="LEFT">102442(1)</td> <td align="LEFT">102445(1)</td> <td align="CENTER">
</td> <td align="CENTER">
</td> </tr> <tr> <td sdval="1" sdnum="1033;" align="CENTER" height="17">1</td> <td sdval="6" sdnum="1033;" align="CENTER">6</td> <td align="LEFT">102249(1)</td> <td align="LEFT">102250(2)</td> <td align="LEFT">102251(2)</td> <td align="LEFT">102445(1)</td> <td align="LEFT">
</td> <td align="CENTER">
</td> </tr> <tr> <td sdval="1" sdnum="1033;" align="CENTER" height="17">1</td> <td sdval="7" sdnum="1033;" align="CENTER">7</td> <td align="LEFT">102249(2)</td> <td align="LEFT">102250(2)</td> <td align="LEFT">102251(2)</td> <td align="LEFT">102445(1)</td> <td align="CENTER">
</td> <td align="CENTER">
</td> </tr> <tr> <td sdval="2" sdnum="1033;" align="CENTER" height="17">2</td> <td sdval="7" sdnum="1033;" align="CENTER">7</td> <td align="LEFT">102249(3)</td> <td align="LEFT">102250(1)</td> <td align="LEFT">102251(1)</td> <td align="LEFT">102253(1)</td> <td align="LEFT">102445(1)</td> <td align="LEFT">
</td> </tr> <tr> <td sdval="1" sdnum="1033;" align="CENTER" height="17">1</td> <td sdval="5" sdnum="1033;" align="CENTER">5</td> <td align="LEFT">102251(2)</td> <td align="LEFT">102252(2)</td> <td align="LEFT">102442(1)</td> <td align="CENTER">
</td> <td align="CENTER">
</td> <td align="LEFT">
</td> </tr> </tbody> </table>
<table width="30" border="0" cellspacing="0" cols="6" frame="VOID" height="30" rules="NONE"><tbody><tr><td width="86" align="LEFT" height="17">
</td><td width="86" align="LEFT">
</td><td width="86" align="LEFT">
</td><td width="86" align="LEFT">
</td><td width="86" align="LEFT">
</td><td width="86" align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td> </tr> </tbody> </table>
Additionally, after the sort, I would like to total the number of like rows and insert that total in column "A" in the front of the rows, deleting all but one of the like rows. Also, there is data in parentheses that I would like to add together, per row and insert the sum in column "B" at the front of the row.
I have attached before and after files.
Thanks for any help. I have spent a lot of time trying to figure this out, but I'm not savvy enough to do it. And if I didn't explain this well enough, I'll try to clarify.
Before sort:
****** http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8"><title></title>****** name="GENERATOR" content="OpenOffice.org 3.1 (Win32)"><style> <!-- BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Arial"; font-size:x-small } --> </style> <table border="0" cellspacing="0" cols="6" frame="VOID" rules="NONE"> <colgroup><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"></colgroup> <tbody> <tr> <td width="86" align="LEFT" height="17">102249(2)</td> <td width="86" align="LEFT">102250(2)</td> <td width="86" align="LEFT">102445(1)</td> <td width="86" align="LEFT">102251(2)</td> <td width="86" align="LEFT">
</td> <td width="86" align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102131(2)</td> <td align="LEFT">102442(1)</td> <td align="LEFT">102445(1)</td> <td align="LEFT">102252(1)</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102249(1)</td> <td align="LEFT">102250(1)</td> <td align="LEFT">102131(2)</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102120(1)</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102131(2)</td> <td align="LEFT">101773(1)</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102120(1)</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102251(2)</td> <td align="LEFT">102252(2)</td> <td align="LEFT">102442(1)</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102120(1)</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102251(1)</td> <td align="LEFT">102252(1)</td> <td align="LEFT">102250(1)</td> <td align="LEFT">102249(1)</td> <td align="LEFT">101890(1)</td> <td align="LEFT">101891(1)</td> </tr> <tr> <td align="LEFT" height="17">102249(3)</td> <td align="LEFT">102251(1)</td> <td align="LEFT">102445(1)</td> <td align="LEFT">102250(1)</td> <td align="LEFT">102253(1)</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102249(3)</td> <td align="LEFT">102445(1)</td> <td align="LEFT">102253(1)</td> <td align="LEFT">102251(1)</td> <td align="LEFT">102250(1)</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102249(1)</td> <td align="LEFT">102131(2)</td> <td align="LEFT">102250(1)</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td align="LEFT" height="17">102250(2)</td> <td align="LEFT">102251(2)</td> <td align="LEFT">102445(1)</td> <td align="LEFT">102249(1)</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> </tbody> </table>
After sort:
****** http-equiv="CONTENT-TYPE" content="text/html; charset=utf-8"><title></title>****** name="GENERATOR" content="OpenOffice.org 3.1 (Win32)"><style> <!-- BODY,DIV,TABLE,THEAD,TBODY,TFOOT,TR,TH,TD,P { font-family:"Arial"; font-size:x-small } --> </style> <table border="0" cellspacing="0" cols="8" frame="VOID" rules="NONE"> <colgroup><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"><col width="86"></colgroup> <tbody> <tr> <td sdval="1" sdnum="1033;" width="86" align="CENTER" height="17">1</td> <td sdval="3" sdnum="1033;" width="86" align="CENTER">3</td> <td width="86" align="LEFT">101773(1)</td> <td width="86" align="LEFT">102131(2)</td> <td width="86" align="CENTER">
</td> <td width="86" align="CENTER">
</td> <td width="86" align="LEFT">
</td> <td width="86" align="LEFT">
</td> </tr> <tr> <td sdval="1" sdnum="1033;" align="CENTER" height="17">1</td> <td sdval="6" sdnum="1033;" align="CENTER">6</td> <td align="LEFT">101890(1)</td> <td align="LEFT">101891(1)</td> <td align="LEFT">102249(1)</td> <td align="LEFT">102250(1)</td> <td align="LEFT">102251(1)</td> <td align="LEFT">102252(1)</td> </tr> <tr> <td sdval="3" sdnum="1033;" align="CENTER" height="17">3</td> <td sdval="1" sdnum="1033;" align="CENTER">1</td> <td align="LEFT">102120(1)</td> <td align="CENTER">
</td> <td align="CENTER">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> <td align="LEFT">
</td> </tr> <tr> <td sdval="2" sdnum="1033;" align="CENTER" height="17">2</td> <td sdval="4" sdnum="1033;" align="CENTER">4</td> <td align="LEFT">102131(2)</td> <td align="LEFT">102249(1)</td> <td align="LEFT">102250(1)</td> <td align="CENTER">
</td> <td align="CENTER">
</td> <td align="LEFT">
</td> </tr> <tr> <td sdval="1" sdnum="1033;" align="CENTER" height="17">1</td> <td sdval="5" sdnum="1033;" align="CENTER">5</td> <td align="LEFT">102131(2)</td> <td align="LEFT">102252(1)</td> <td align="LEFT">102442(1)</td> <td align="LEFT">102445(1)</td> <td align="CENTER">
</td> <td align="CENTER">
</td> </tr> <tr> <td sdval="1" sdnum="1033;" align="CENTER" height="17">1</td> <td sdval="6" sdnum="1033;" align="CENTER">6</td> <td align="LEFT">102249(1)</td> <td align="LEFT">102250(2)</td> <td align="LEFT">102251(2)</td> <td align="LEFT">102445(1)</td> <td align="LEFT">
</td> <td align="CENTER">
</td> </tr> <tr> <td sdval="1" sdnum="1033;" align="CENTER" height="17">1</td> <td sdval="7" sdnum="1033;" align="CENTER">7</td> <td align="LEFT">102249(2)</td> <td align="LEFT">102250(2)</td> <td align="LEFT">102251(2)</td> <td align="LEFT">102445(1)</td> <td align="CENTER">
</td> <td align="CENTER">
</td> </tr> <tr> <td sdval="2" sdnum="1033;" align="CENTER" height="17">2</td> <td sdval="7" sdnum="1033;" align="CENTER">7</td> <td align="LEFT">102249(3)</td> <td align="LEFT">102250(1)</td> <td align="LEFT">102251(1)</td> <td align="LEFT">102253(1)</td> <td align="LEFT">102445(1)</td> <td align="LEFT">
</td> </tr> <tr> <td sdval="1" sdnum="1033;" align="CENTER" height="17">1</td> <td sdval="5" sdnum="1033;" align="CENTER">5</td> <td align="LEFT">102251(2)</td> <td align="LEFT">102252(2)</td> <td align="LEFT">102442(1)</td> <td align="CENTER">
</td> <td align="CENTER">
</td> <td align="LEFT">
</td> </tr> </tbody> </table>
<table width="30" border="0" cellspacing="0" cols="6" frame="VOID" height="30" rules="NONE"><tbody><tr><td width="86" align="LEFT" height="17">
</td><td width="86" align="LEFT">
</td><td width="86" align="LEFT">
</td><td width="86" align="LEFT">
</td><td width="86" align="LEFT">
</td><td width="86" align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td></tr><tr><td align="LEFT" height="17">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td><td align="LEFT">
</td> </tr> </tbody> </table>