You are previewing an Excel file in Power Query Editor by using Power BI Desktop. The file contains data in two columns. One column lists categories. The other column lists subcategories in each category. You need to transform the data to a table that has a separate column for each category and contains the count of subcategories for each category. What transform should you use? Select only one answer. Pivot Promote headers Transpose Unpivot