Santander Interview Question

I was asked about Pivot in Excel