Hi there,
Could you tell me how I can transform table 1 layout below to table 2 layout please. Table 1 list similar products in groups by placing them straight after another and use a blank cell(s) to differential from a different group. In order for me to make use of the data, I need to transform the data into table 2 layout, where it shows the products and the alternative products.
Any help will be very much appreciated.
Table 1
<colgroup><col></colgroup><tbody>
</tbody>
Table 2
<colgroup><col><col></colgroup><tbody>
</tbody>
Could you tell me how I can transform table 1 layout below to table 2 layout please. Table 1 list similar products in groups by placing them straight after another and use a blank cell(s) to differential from a different group. In order for me to make use of the data, I need to transform the data into table 2 layout, where it shows the products and the alternative products.
Any help will be very much appreciated.
Table 1
Product |
JK2309 |
KN4506 |
JN3950 |
VN3890 |
JK1983 |
DE39833 |
DN2928 |
NJ92 |
NH12 |
KO12 |
<colgroup><col></colgroup><tbody>
</tbody>
Table 2
Product | Alternative Product |
JK2309 | KN4506 |
JK2309 | JN3950 |
KN4506 | JK2309 |
KN4506 | JN3950 |
JN3950 | JK2309 |
JN3950 | KN4506 |
VN3890 | JK1983 |
VN3890 | DE39833 |
VN3890 | DN2928 |
VN3890 | NJ92 |
JK1983 | VN3890 |
JK1983 | DE39833 |
JK1983 | DN2928 |
JK1983 | NJ92 |
DE39833 | VN3890 |
DE39833 | JK1983 |
DE39833 | DN2928 |
DE39833 | NJ92 |
DN2928 | VN3890 |
DN2928 | JK1983 |
DN2928 | DE39833 |
DN2928 | NJ92 |
NJ92 | VN3890 |
NJ92 | JK1983 |
NJ92 | DE39833 |
NJ92 | DN2928 |
NH12 | KO12 |
KO12 | NH12 |
<colgroup><col><col></colgroup><tbody>
</tbody>