Hi All,
With your kind help I need to figure out a way to group information to create a new worksheet,organized in a different way then what I have now.
As shown in the below example , I need to first look at column B to find duplicates, than to put whatever is in column A of the duplicate in the row next to B.
If you look all the way down, rows 38,39 is manually done what I'm looking for a trick to do(on about 6000 records,and it cannot be done manually)
The end result will be the content of B and next to it side by side in a row the content of all matching A's
Thank you in advance
<table style="width: 273px; height: 1014px;" border="2" cellspacing="0"><tbody><tr valign="bottom"><th bgcolor="#b0b0b0" width="22">
</th><th align="center" bgcolor="#b0b0b0" width="76">A</th><th align="center" bgcolor="#b0b0b0" width="73">B</th><th align="center" bgcolor="#b0b0b0" width="73">C</th><th align="center" bgcolor="#b0b0b0" width="73">D</th><th align="center" bgcolor="#b0b0b0" width="73">E</th></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">1</th><td width="61">xlm1</td><td width="59">yes-0-1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">2 </th><td width="61">xlm2</td><td width="59">to 13.19</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">3 </th><td width="61">xlm3</td><td width="59">old 15-6</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">4 </th><td width="61">mrc5</td><td width="59">old 1218.3,1,1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">5 </th><td width="61">xlm5</td><td width="59">ert35-13</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">6 </th><td width="61">mrc13</td><td width="59">yes-0-1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">7 </th><td width="61">xlm7</td><td width="59">trd*r-1-2-0</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">8 </th><td width="61">wsa23</td><td width="59">ert35-13</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">9 </th><td width="61">xlm9</td><td width="59">no-110</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">10 </th><td width="61">obp12</td><td width="59">to 13.19</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">11 </th><td width="61">wsd19</td><td width="59">old 1218.3,1,1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">12 </th><td width="61">xlm12</td><td width="59">ert35-13</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">13 </th><td width="61">xlm13</td><td width="59">trd*r-1-2-0</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">14 </th><td width="61">trc2</td><td width="59">to 13.19</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">15 </th><td width="61">erf90</td><td width="59">ert35-13</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">16 </th><td width="61">trc4</td><td width="59">no-110</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">17 </th><td width="61">trc5</td><td width="59">tyn-bbs-1-1-1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">18 </th><td width="61">trc6</td><td width="59">yes-0-1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">19 </th><td width="61">trc7</td><td width="59">Bash13-0-1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">20 </th><td width="61">lbt6</td><td width="59">trd*r-1-2-0</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">21 </th><td width="61">trc9</td><td width="59">old 1218.3,1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">22 </th><td width="61">trc10</td><td width="59">tyn-bbs-1-1-1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">23 </th><td width="61">trc11</td><td width="59">Bash13-0-1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">24 </th><td width="61">ynt5</td><td width="59">old 1218.3,1,1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">25 </th><td width="61">trc13</td><td width="59">shell3.1.1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">26 </th><td width="61">trc14</td><td width="59">no-110</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">27 </th><td width="61">ltt9</td><td width="59">ert35-13</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">28 </th><td width="61">ltt10</td><td width="59">yes-0-1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">29 </th><td width="61">ynt3</td><td width="59">Bash13-0-1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">30 </th><td width="61">ltt12</td><td width="59">old 13.3,1,1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">31 </th><td width="61">xtr008</td><td width="59">old 1218.3,1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">32 </th><td width="61">ltt14</td><td width="59">old 15-6</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">33 </th><td width="61">xtn001</td><td width="59">no-110</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">34 </th><td width="61">ltt16</td><td width="59">to 13.19</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">35 </th><td width="61">
</td><td width="59">
</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">36 </th><td width="61">
</td><td width="59">
</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">37 </th><td width="61">
</td><td width="59">
</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">38 </th><td width="61">yes-0-1</td><td width="59">xlm1</td><td width="59">mrc13</td><td width="59">trc6</td><td width="59">ltt10</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">39</th><td width="61">old 1218.3,1,1</td><td width="59">mrc5</td><td width="59">wsd19</td><td width="59">ynt5</td><td width="59">
</td></tr></tbody></table>
With your kind help I need to figure out a way to group information to create a new worksheet,organized in a different way then what I have now.
As shown in the below example , I need to first look at column B to find duplicates, than to put whatever is in column A of the duplicate in the row next to B.
If you look all the way down, rows 38,39 is manually done what I'm looking for a trick to do(on about 6000 records,and it cannot be done manually)
The end result will be the content of B and next to it side by side in a row the content of all matching A's
Thank you in advance
<table style="width: 273px; height: 1014px;" border="2" cellspacing="0"><tbody><tr valign="bottom"><th bgcolor="#b0b0b0" width="22">
</th><th align="center" bgcolor="#b0b0b0" width="76">A</th><th align="center" bgcolor="#b0b0b0" width="73">B</th><th align="center" bgcolor="#b0b0b0" width="73">C</th><th align="center" bgcolor="#b0b0b0" width="73">D</th><th align="center" bgcolor="#b0b0b0" width="73">E</th></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">1</th><td width="61">xlm1</td><td width="59">yes-0-1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">2 </th><td width="61">xlm2</td><td width="59">to 13.19</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">3 </th><td width="61">xlm3</td><td width="59">old 15-6</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">4 </th><td width="61">mrc5</td><td width="59">old 1218.3,1,1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">5 </th><td width="61">xlm5</td><td width="59">ert35-13</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">6 </th><td width="61">mrc13</td><td width="59">yes-0-1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">7 </th><td width="61">xlm7</td><td width="59">trd*r-1-2-0</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">8 </th><td width="61">wsa23</td><td width="59">ert35-13</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">9 </th><td width="61">xlm9</td><td width="59">no-110</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">10 </th><td width="61">obp12</td><td width="59">to 13.19</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">11 </th><td width="61">wsd19</td><td width="59">old 1218.3,1,1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">12 </th><td width="61">xlm12</td><td width="59">ert35-13</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">13 </th><td width="61">xlm13</td><td width="59">trd*r-1-2-0</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">14 </th><td width="61">trc2</td><td width="59">to 13.19</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">15 </th><td width="61">erf90</td><td width="59">ert35-13</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">16 </th><td width="61">trc4</td><td width="59">no-110</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">17 </th><td width="61">trc5</td><td width="59">tyn-bbs-1-1-1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">18 </th><td width="61">trc6</td><td width="59">yes-0-1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">19 </th><td width="61">trc7</td><td width="59">Bash13-0-1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">20 </th><td width="61">lbt6</td><td width="59">trd*r-1-2-0</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">21 </th><td width="61">trc9</td><td width="59">old 1218.3,1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">22 </th><td width="61">trc10</td><td width="59">tyn-bbs-1-1-1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">23 </th><td width="61">trc11</td><td width="59">Bash13-0-1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">24 </th><td width="61">ynt5</td><td width="59">old 1218.3,1,1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">25 </th><td width="61">trc13</td><td width="59">shell3.1.1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">26 </th><td width="61">trc14</td><td width="59">no-110</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">27 </th><td width="61">ltt9</td><td width="59">ert35-13</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">28 </th><td width="61">ltt10</td><td width="59">yes-0-1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">29 </th><td width="61">ynt3</td><td width="59">Bash13-0-1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">30 </th><td width="61">ltt12</td><td width="59">old 13.3,1,1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">31 </th><td width="61">xtr008</td><td width="59">old 1218.3,1</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">32 </th><td width="61">ltt14</td><td width="59">old 15-6</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">33 </th><td width="61">xtn001</td><td width="59">no-110</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">34 </th><td width="61">ltt16</td><td width="59">to 13.19</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">35 </th><td width="61">
</td><td width="59">
</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">36 </th><td width="61">
</td><td width="59">
</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">37 </th><td width="61">
</td><td width="59">
</td><td width="59">
</td><td width="59">
</td><td width="59">
</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">38 </th><td width="61">yes-0-1</td><td width="59">xlm1</td><td width="59">mrc13</td><td width="59">trc6</td><td width="59">ltt10</td></tr><tr valign="bottom"><th align="center" bgcolor="#b0b0b0" height="12" width="18">39</th><td width="61">old 1218.3,1,1</td><td width="59">mrc5</td><td width="59">wsd19</td><td width="59">ynt5</td><td width="59">
</td></tr></tbody></table>