Unpivot Other Columns in Fabric Dataflow
Short answer
C Select the VendorID column and choose Unpivot other columns to keep it as an identifier while transforming the remaining columns into rows.
Question
You have a Fabric workspace named Workspace1 that contains a data flow named Dataflow1 contains a query that returns the data shown in the following exhibit. You need to transform the data columns into attribute-value pairs, where columns become rows. You select the VendorID column. Which transformation should you select from the context menu of the VendorID column? - 
Key Takeaways
The question tests Power Query transformation logic: selecting an anchor column and unpivoting the remaining columns requires the 'Unpivot other columns' option, not 'Unpivot columns'.
Learn how to transform data columns into attribute-value pairs in a Microsoft Fabric data flow. Selecting the identifier column and using the 'Unpivot other columns' transformation correctly keeps the key column while pivoting the remaining columns into rows.
Common mistake: Choosing 'Unpivot columns' (B) which would pivot the selected VendorID column instead of the remaining attribute columns.
Expert Analysis
Why the Answer Is Correct
The requirement is to transform columns into attribute-value pairs (rows) while retaining the VendorID column as an identifier. By selecting the VendorID column and choosing 'Unpivot other columns', Power Query keeps VendorID intact and unpivots all other columns into two new Attribute and Value columns. This perfectly matches the stated goal of converting columns to rows for the non-VendorID data.Why the Other Options Are Wrong
'Group by' aggregates data rather than reshaping it. 'Unpivot columns' would unpivot the selected VendorID column itself, destroying its use as an identifier. 'Split column' divides a single column's values into multiple columns based on a delimiter. 'Remove other columns' deletes unselected columns entirely rather than transforming them into rows.Community Comment Notes
Users agree that 'Unpivot other columns' is the correct choice because it unpivots the unselected columns while retaining the selected one. As stilferx noted, this command is used 'when not all columns are known' and ensures 'new columns added during a refresh operation are also unpivoted'.Official Reference
Exam Strategy
When asked to keep a specific column and transform the rest into rows, select the column to keep and use 'Unpivot other columns'. If you need to unpivot only specific selected columns, use 'Unpivot columns'.
Community Votes
100% of anonymous learners picked answer C. Votes are pick records left by other test-takers — they are not the verified answer.
Discussion 5 contributions
Compiled from public community threads and reader submissions, lightly edited for clarity. Handles and vote tallies are shown as recorded.
From public community threads 5
-
stilferx 👍 3 Answered CIMHO, "C", Because of: Unpivot other columns This command unpivots unselected columns. Use this command in a query when not all columns are known. New columns added during a refresh operation are also unpivoted. description is here: https://support.microsoft.com/en-us/office/unpivot-columns-power-query-0f7bad4b-9ea1-49c1-9d95-f588221c7098#:~:text=Select%20the%20columns%20you%20do,Transform%20%3E%20Unpivot%20Only%20Selected%20Columns.
-
Momoanwar 👍 11 Answered CCorrect
-
XiltroX 👍 3C is the correct answer
-
Rakesh16 👍 1 Answered CUnpivot other columns
-
Nefirs 👍 1 Answered Cclearly C
Reader comments & corrections
No reader corrections yet — spotted an error or have a note? Share it below.
Related Analysis
Practice All DP-600 Questions
Access 115 questions with complete answers and detailed explanations.
View Full DP-600 Practice Test →