Create a basic table - Columns independent of each other

[Matt22365]

Hi

I hope someone can help

I have a set of data layed out in columns. Example data attached. 

Project Number	Department	Partner	Status	In Plan / Out of Plan	Value
1	Dept 1	Partner 1	On Time	In	£14.00
2	Dept 2	Partner 2	Delayed	Out	£3.00
3	Dept 3	Partner 3	Delayed	Out	£18.00
4	Dept 1	Partner 1	Delayed	In	£22.00
5	Dept 2	Partner 2	On time	In	£104.00
6	Dept 3	Partner 3	On Time	In	£19.00
7	Dept 1	Partner 1	Delayed	Out	£25.00
8	Dept 2	Partner 2	On Time	In	£3.00
9	Dept 3	Partner 3	Delayed	In	£28.00
10	Dept 1	Partner 1	Delayed	Out	£4.00

What I would like is a table where the Department and Partner columns can be used as slicers for the whole data set, but the count of: Status; Launch; Value columns are tabulated independent of each other. 

I attached an example of what I would like the end point to be

Pillar or Partner	Status	In Plan	Value
All
Dept 1
Dept 2
Dept 3
Partner 1
Partner 2
Partner 3

Thanks for your help

Matt 

[v-chuncz-msft · Accepted solution]

@Matt22365 

You may select Unpivot Columns in Query Editor first.