Table Structure (Cross-tab?)

[ArminL]

Hey everybody,

I have a problem with a table structure, which can probably be solved with a cross tab tool. Still I can't figure out how to configure it to get the right ouput. maybe somebody could quickly help me with that minor problem :) Here is what I have right now:

Label	Category	Value
Mood	Aggresive	1
Mood	Quiet	0
Mood	Relaxing	0
Artist	A	0
Artist	B	1
Artist	C	0
Genre	Jazz	0
Genre	Rock	1
Genre	Pop	0

and this is how I need it: 

Mood	Artist	Genre	Value
Aggresive			1
Quiet			0
Relaxing			0
	A		0
	B		1
	C		0
		Jazz	0
		Rock	1
		Pop	0

Thanks in advance and cheers,

Armin

[vishwa_0308 · Accepted solution]

Hi @ArminL,

Please go through with attached workflow, it will get exactly as u required.

Thanks,

Vishwa

[ArminL]

many thanks!