I need help with a macro that will transform the following table:
<tbody>
</tbody>
So that it ends up looking like the table below:
<tbody>
</tbody>
This sample is much smaller than the actual data I am working with. the MFR & MPN can be as high as MFR36, MPN36 and can be over 1000 rows. Any help is much appreciated. Thanks!
Component P/N | Rev | Qty | BUn | Description | Mfg Name | Mfr Part Number | ||||
130-158-01-02 |
<tbody> </tbody> | 1 |
<tbody> </tbody> |
<tbody> </tbody> | ||||||
<tbody> </tbody> |
<tbody> </tbody> | 1 |
<tbody> </tbody> |
<tbody> </tbody> | ||||||
<tbody> </tbody> | 23 |
<tbody> </tbody> |
<tbody> </tbody> | |||||||
<tbody> </tbody> |
<tbody> </tbody> | |||||||||
<tbody> </tbody> |
<tbody> </tbody> | |||||||||
<tbody> </tbody> | 8 |
<tbody> </tbody> |
<tbody> </tbody> | |||||||
<tbody> </tbody> |
<tbody> </tbody> | |||||||||
<tbody> </tbody> |
<tbody> </tbody> | |||||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
So that it ends up looking like the table below:
Component P/N | Rev | Qty | BUn | Description | MFR1 | MPN1 | MFR2 | MPN2 | MFR3 | MPN3 | ||||||
130-158-01-02 | D2 | 1 | EA | Display/System uP,Jabron | ||||||||||||
<tbody> </tbody> | G3 | 1 | EA | PCBA,System Contlr,Jabroni | ||||||||||||
402-745-01-00 | 23 | EA | CAP,X5R,123FG,26V,9%,0806 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||||||
437-123-01-00 | 8 | EA | RES,10.0K,1%,0806 |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>
This sample is much smaller than the actual data I am working with. the MFR & MPN can be as high as MFR36, MPN36 and can be over 1000 rows. Any help is much appreciated. Thanks!