Microsoft
70-779 · Question #66
From a workbook query, you import a table that has the following data. You need to configure the table to appear as shown in the following table.
The correct answer is C. From the Split Column menu, click By Delimiter. Trim removes only leading and ending empty spaces, it cannot delete whole words. Ideally it should be "From the Extract Menu click Before Delimiter".
Consume and transform data by using Microsoft Excel
Question
From a workbook query, you import a table that has the following data. You need to configure the table to appear as shown in the following table.
Options
- AFrom the Format menu, click Trim.
- BFrom the Format menu, click Clean.
- CFrom the Split Column menu, click By Delimiter.
- DFrom the Extract menu, click Last Characters.
How the community answered
(39 responses)- A5% (2)
- B8% (3)
- C72% (28)
- D15% (6)
Explanation
Trim removes only leading and ending empty spaces, it cannot delete whole words. Ideally it should be "From the Extract Menu click Before Delimiter".
Topics
#Split Column#delimiter#Power Query#data transformation
Community Discussion
No community discussion yet for this question.