power pivot rearranging

[nil71]

hi everyone,
i have a power pivot that contains different metrics for every SKU in different dates,
like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]
date[/TD]
[TD]SKU ID[/TD]
[TD]color [/TD]
[TD]forsalestock[/TD]
[/TR]
[TR]
[TD]2/8/2018[/TD]
[TD]293774[/TD]
[TD]red [/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]2/15/2018[/TD]
[TD]293774[/TD]
[TD]orange[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]


i want to rearrange this power pivot to reference specific column for every SKU in a week,for example trying to compare the forsalestock of each SKU week over week. like this:
[TABLE="width: 500"]
<tbody>[TR]
[TD]SKU ID[/TD]
[TD]color(week 2/8/2018)[/TD]
[TD]color(week 2/15/2018)[/TD]
[TD]forsalestock(week 2/8/2018)[/TD]
[TD]forsalestock(week 2/15/2018)[/TD]
[/TR]
[TR]
[TD]293774[/TD]
[TD]red[/TD]
[TD]orange[/TD]
[TD]15[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]

how can i do that? Is there any formula?
thanks in advance.