DRAG DROP
You use a workbook query to import a table named Customers that contains a column named CustomerName. CustomerName has names in the format of Lastname, Firstname.
You need the CustomerName column to contain names in the format of Firstname Lastname. A space must separate Firstname and Lastname.
Which two commands should you use? To answer, drag the appropriate fields to the correct areas. Each field may be used once, more than once, or not at all.
You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:
The answer seems wrong to me … If you try to replicate it the answer should be: Split and then Merge (once you can merge with space).
Yep, thats correct!
Yes R is correct. The complete answer is: First Command: Split Column by Delimiter and Second Command: Merge Columns