70-779 Exam Dumps | You have a query that retrieves customers and their locations. You have a sample of the data as shown

<< Prev Question Next Question >>

You have a query that retrieves customers and their locations. You have a sample of the data as shown in the following table.

Additional customers and locations are added frequently.
You need to transform the data as shown in the following table.

What should you do?

A. Select the Customer columns, and then click Unpivot Columns.

B. Select the Locations columns and then select Split Column by Delimiter. Use a comma as the delimiter and split into rows.

C. Select the Locations columns and then select Split Column by Delimiter. Use a comma as the delimiter and split into columns.

D. Select the Customer columns, and then click Unpivot Other Columns.

Download PDF File