Question

Columns option splits the text into two or more columns.-Justify your answer.

Answer 1

Split Column: By Delimiter a text value is split into two or more columns according to a common character.

Say for example, a Name column is split as as Last Name, First Name into two columns using the comma (,) character.  

You can select the column you want to split. In the Query Editor ribbon, Split is selected as  Column > By Delimiter.