Source table:
<tbody>
</tbody>
I would like to create 1 row in a new table for every combination of these 3 columns with a '-' separator between each value.
For example, for ATB, I need 1 row for each fabric in each of the 5 sizes, so 25 SKU's:
ATB-G901-C
ATB-G901-K
and so on until ATB-G905-T
This is just a very small snapshot of the true table.
In the true table there are close to 130 frames and 150 fabrics.
Many thanks in advance for any help given.
Frame | Fabric | Size |
ATB | G901 | C |
ATBN | G902 | K |
FMB | G903 | Q |
FMBN | G904 | F |
G905 | T |
<tbody>
</tbody>
I would like to create 1 row in a new table for every combination of these 3 columns with a '-' separator between each value.
For example, for ATB, I need 1 row for each fabric in each of the 5 sizes, so 25 SKU's:
ATB-G901-C
ATB-G901-K
and so on until ATB-G905-T
This is just a very small snapshot of the true table.
In the true table there are close to 130 frames and 150 fabrics.
Many thanks in advance for any help given.