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