Pivot table with string data in cells

Hi,

I have table with three columns (company id, product id, state of order) , all columns are string type:

CompID|ProductID|OrderSate

1|1|0

1|50|1

1|100|3

2|3|0

2|33|0

Can I make pivot table with Order State in cells? Something like this:

CompID/ProductID|1|3|33|50|100

           1               |0|?| ? | 1 |  3 

           2               |?|0| 0 | ? |  ?

Thank you for the answer

Yes, by using the GroupBy (on CompID and ProductID), Sorter (on ProductID), and then the Pivoting (CompID vs. ProductID + Aggregation).