I have a table of data like this:
ID |Name |Brand |Model |License
------------------------------------
1 |Foo |KOM |830 AC |A
1 |Foo |KOM |930 E |B
1 |Foo |CAT |980 H |B
2 |Bar |KOM |930 E |A
2 |Bar |CAT |980 H |A
3 |Baz |P&H |280 XB |B
The ID and Name are tied together(ID 1 is always Foo), also there is never more than one license for a pair of Name and Model)
I want to use a pivot table to turn it into this:
| |CAT |KOM |P&H
ID |Name |980 H |830 AC |930 E |280 XB
-------------------------------------------
1 |Foo |B |A |B |
2 |Bar |A | |A |
3 |Baz | | | |B
This is as far as I've gotten:
But:
- Ids and Names are in different rows
- It shows the count (always 1) of licenses instead of showing the values
Is there a way to make it work the way I want?