Post data of Store in another way

[kashifk]

I have the following Data - a Sample

Item	Sales Person Name	Sales
Tie	Andrew	500
Tie	Benett	400
Tie	Raees	300
Belt	Andrew	100
Belt	Benett	150
Belt	Raees	280
Shoe	Andrew	650
Shoe	Benett	100
Shoe	Raees	280

Now I want to put it this way

	Andrew	Benett	Raees
Tie	500	400	300
Belt	100	150	280
Shoe	650	100	280

I need this to present in this way, but I don't know how to do it in Power Query.  Thanks in Advance

[Ritaf1983 · Accepted solution]

Hi @kashifk 

You don't need to make changes to the data structure by PQ to present your data in the desired way.
We have a Matrix visual for it :
(if you don't need row / column totals you can switch them off

For more information about matrixes please refer:

https://learn.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly