From Power BI Desktop, you create a query that imports the following table.



You need to configure the table to appear as shown in the following table:



What should you do?

A. From the Format menu, click Trim.

B. From the Extract menu, click Last Characters.

C. From the Split Column menu, click By Delimiter.

D. From the Extract menu, click Text After Delimiter.

References: https://msdn.microsoft.com/en-us/library/mt798301.aspx