I am struggling with something and maybe it is the shear number of times I have to do this. So I have output I received from 30,888 cells (lets call them "finished goods" - below my finished good is: "FW15RH20.KBSTVS.GDRB60"). Now, I need to pair each of the "finished goods with 20 different items like shown below. Each "finished goods" cell is paired with 2 other columns (0,A).
This is an example of 1 "finished goods" paired with the columns, remember, I have 30,888 of these, HOW DO I DO THIS?
<tbody>
</tbody>
This is an example of 1 "finished goods" paired with the columns, remember, I have 30,888 of these, HOW DO I DO THIS?
<colgroup><col><col></colgroup><tbody> </tbody> | 0 | A | |||
<tbody> </tbody> | 1 | B | |||
<tbody> </tbody> | 2 | C | |||
<tbody> </tbody> | 3 | D | |||
<tbody> </tbody> | 4 | E | |||
<tbody> </tbody> | 5 | F | |||
<tbody> </tbody> | 6 | G | |||
<tbody> </tbody> | 7 | H | |||
<tbody> </tbody> | 8 | I | |||
<tbody> </tbody> | 9 | J | |||
<tbody> </tbody> | 10 | K | |||
<tbody> </tbody> | 11 | L | |||
<tbody> </tbody> | 12 | M | |||
<tbody> </tbody> | 13 | N | |||
<tbody> </tbody> | 14 | O | |||
<tbody> </tbody> | 15 | P | |||
<tbody> </tbody> | 16 | Q | |||
<tbody> </tbody> | 17 | R | |||
<tbody> </tbody> | 18 | S | |||
<tbody> </tbody> | 19 | T | |||
<tbody> </tbody> | 20 | U |
<tbody>
</tbody>