Power BI - Data Cleaning with Power Query
What is the main purpose of the
Table.Transpose function in Power BI's Power Query?What is the main purpose of the Table.Transpose function in Power BI's Power Query?
easy📝 Conceptual Q1 of 15
Step-by-Step Solution
Solution:
Step 1: Understand the function's action
Table.Transposechanges the orientation of data by swapping rows and columns.Step 2: Compare with other options
Filtering, merging, and sorting are different operations unrelated to transposing.Final Answer:
To switch rows into columns and columns into rows -> Option AQuick Check:
Transpose = Switch rows and columns [OK]
Quick Trick: Transpose flips rows and columns in a table [OK]
Common Mistakes:
- Confusing transpose with filtering or sorting
- Thinking transpose merges tables
- Assuming transpose changes data values
Master "Data Cleaning with Power Query" in Power BI
Want More Practice?
15+ quiz questions · All difficulty levels · Free
Free Signup - Practice All QuestionsMore Power BI Quizzes