The column to list tool is usually usefull when you have a list of column fields that you want to translate to a list. For example, from some SQL IDE you can select the column names and with this tool converts it to a list that you can reuse for a SELECT. You can also use it to transform distinct unique values rows from a select to a list.