Trying to convert data from the old spread sheet Table A below to the a new one Table B format. Is it possible?
Table A
<tbody>
</tbody>
Table B
<tbody>
</tbody>
Thank you.
Table A
style | model | Atttibute | Attribute_Value |
A-01 | A-01 | Color | Blue |
A-01 | A-01 | Shape | Rectangle |
A-01 | A-01 | Material | Leather |
A-01 | A-01 | Pattern | Geometric |
A-01 | A-01s | Size | Small |
A-01 | A-01m | Size | Medium |
A-02 | A-02 | Color | Red |
A-02 | A-02 | Shape | Round |
A-02 | A-02 | Material | Fabric |
A-02 | A-02 | Pattern | Strip |
A-02 | A-02-s | Size | small |
A-02 | A-02-m | Size | Medium |
A-02 | A-02-l | Size | Large |
<tbody>
</tbody>
Table B
style | model | relation | Size | Color | Shape | Material | Pattern |
A-01 | A-01-s | child | Small | Blue | Rectangle | Leather | Geometric |
A-01 | A-01-m | child | Medium | Blue | Rectangle | Leather | Geometric |
A-01 | A-01 | parent | Blue | Rectangle | Leather | Geometric | |
A-02 | A-02-s | child | small | Red | Round | Fabric | Strip |
A-02 | A-02-m | child | Medium | Red | Round | Fabric | Strip |
A-02 | A-02-l | child | Large | Red | Round | Fabric | Strip |
A-02 | A-02 | parent | Red | Round | Fabric | Strip |
<tbody>
</tbody>
Thank you.
Last edited: