Question $10$

We have one more transformation to make on our Expenses query, the amounts are currently shown in $3$ separate columns $($one for each month$)$ which will make it difficult to do our analysis. We want to put all the amounts in a single column and have a separate column with the Month name in it$.$ Start by selecting the first $3$ columns $($EXPENSE TYPE, CODE & STAFF ID$).$ Which of the following options do you need to apply to achieve the required outcome?

$1$ point

Unpivot Only Selected Columns

Unpivot Other Columns

Pivot Columns

Unpivot Columns