How to create crosstab with two field in bigquery with standart or legacy sql

Question

I want to get two columns from table and create a crosstab to see how many product bought in which product category for each customer. Here is an example data from my table:

Row     Customer_ID     Style    
 1      MEM014          BLS87    
 2      KAR810          DR126    
 3      NIKE61          MMQ5     
 4      NIKE61          MMQ5     
 5      STT019          BLS83    
 6      STT019          BLS84    
 7      STT019          BLS87    

And I want to get result table like this:

Customer - DR126 - MMQ5 - BLS83 - BLS84 - BLS87
MEM014       0       0      0       0       1
KAR810       1       0      0       0       0
NIKE61       0       2      0       0       0
STT019       0       0      1       1       1   

Answer 1

Waitting for answers