Power Query Unpivot, then next

[bodol32]

Hello,

I want to know how I can create Table C  from Table A  in Power Query. 

Using Unpivot, I come to have Table B, now I  am struggling to find a solution to create Table C.

Please help!

Table A

Table B

Table C

[AlB]

Hi @bodol32 

It looks like you just have to pivot Item and Value in table B and that should be it. If you paste the first table here in text-tabular form (instead of a creen capture) I can run a quick test and post the exact steps (if you do need that ).

Please mark the question solved when done and consider giving kudos if posts are helpful.

Contact me privately for support with any larger-scale BI needs

Cheers 

[bodol32]

Hey AiB

Thank you for sharing your experties here.

Site	Item	1/1/2019	2/1/2019
Site A	aaa	10	8
Site A	bbb	20	16
Site B	aaa	15	12
Site B	bbb	25	20
Site C	aaa	5	4
Site C	bbb	6	4.8

[bodol32 · Accepted solution]

I have solved this!!

First, select date columns and 'Unpivot Column'

then, select item column and  'Pivot Column'

done!