PdfPrep.com

Which two commands should you use?

DRAG DROP

You use a workbook query to import a table named Customers that contains a column named CustomerName. Has names in the format of Lastname, Firstname.

You need the CustomerName column to contain names in the format of FirstnameLastname. A space must separate Firstname and lastname.

Which two commands should you use? To answer, drag the appropriate commands to the correct targets. Each command may be used once, more than once, or not at all. You may need to frag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Answer:

Explanation:

https://support.office.com/en-us/article/split-a-column-of-text-power-query-5282d425-6dd 0-46ca-95bf-8e0da9539662

https://support.office.com/en-us/article/merge-columns-power-query-80ec9e1e-1eb6-4048-b500-d5d42d9f0a8d

Exit mobile version