BNP Paribas interview question

Pivot table creation based on certain parameters