Q. In Power Query, which operation allows transformation of column values like splitting names?

A
Merge Queries
B
Group By
C
Split Column
D
Remove Duplicates
Solution:

The Split Column feature in Power Query is used to divide a column’s data based on a delimiter (like space or comma), often used to split full names into first and last names.

Entri PDF Icon

Get Question Bank

Strengthen Your Practice with our comprehensive question bank.

Entri Contact Image

Get Expert Advice for Free: Register for Your Free Consultation Now!