What should you do?

You have a query that retrieves customers and their locations. You have 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 Locations columns and the select split column by delimiter. Use a comma as the delimiter and split into rows.
B . Select the Customer columns, and then click Unpivot Columns.
C . Select the Customer columns, and then click Unpivot other Columns.
D . Select the Location columns and then select split column by delimiter. Use a comma as the delimiter and split into columns.

View Answer

Answer: A