You have an Excel spreadsheet that contains two columns as follows: Category: Contain names of categories Subcategory: Contain names of subcategories for each category You import the Excel spreadsheet into Power BI Desktop. You need to transform the data to meet the following requirements: Have multiple columns, where one column represents one category Have a single row that includes the total count of subcategories for each category Which transformation should you use? Pivot Columns Unpivot Columns Rename Columns Transpose Columns