Power BI Data Analyst (PL-300) · Free practice question 3 of 12
Split column into rows
Each row of a Courses table holds a semicolon-separated list of trainers in the Trainers column, such as "Lund;Achebe;Ruiz". The model needs one row per course and trainer. Which transformation achieves this in one step?
- A.Transpose the Trainers column
- B.Group By Course with an All Rows aggregation
- C.Split Column by Delimiter using a semicolon, with the advanced option to split into rows
- D.Split Column by Delimiter using a semicolon, with the default option to split into columns
Show answer and explanation
Correct answer: C. Split Column by Delimiter using a semicolon, with the advanced option to split into rows
Why: Splitting by a delimiter into rows creates a separate row for each value in the list while repeating the other columns, giving one row per course and trainer. Splitting into columns creates Trainers.1, Trainers.2 and so on, which would still need unpivoting. Grouping nests rows instead of separating them, and transposing swaps rows and columns of the whole table.