Pivot + Unpivot Solutions

[SushiAddict]

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!

[SushiAddict · Accepted solution]

I found a solution in another post:

https://community.powerbi.com/t5/Power-Query/Pivot-Unpivot-Multiple-values/m-p/2919457#M92117