Santander interview question

I was asked about Pivot in Excel