Hello,
I am trying to accomplish a table transformation that I believe requires some for of unpivoting/pivoting, however I have not yet figured it out.
I am looking to transform a table from this:
| Time | Item 1 Color | Item 2 Color | Item 3 Color | Item 1 Size | Item 2 Size | Item 3 Size |
| 1 | Blue | Blue | Yellow | 5 | 3 | 10 |
| 2 | Blue | Green | Yellow | 5 | 3 | 10 |
| 3 | Green | Green | Yellow | 4 | 3 | 10 |
| 4 | Green | Green | Yellow | 4 | 3 | 12 |
| 5 | Green | Green | Yellow | 4 | 3 | 12 |
To this:
| Time | Item | Color | Size |
| 1 | Item 1 | Blue | 5 |
| 1 | Item 2 | Blue | 3 |
| 1 | Item 3 | Yellow | 10 |
| 2 | Item 1 | Blue | 5 |
| 2 | Item 2 | Green | 3 |
| 2 | Item 3 | Yellow | 10 |
Any help is appreciated!
