Interactive Lessons

Dive into new analytics techniques with lessons that incorporate videos, hands-on activities and quizzes to assess your knowledge.

Also available in | Français | Português | Español | 日本語

Separating Data into Columns and Rows

Back to Lessons Feedback
Alteryx Alumni (Retired)


Lesson Objective: Learn how to split delimited data into columns and rows using the Text to Columns tool in the Designer. 

Estimated Time: ~5 Minutes


  • Understand how delimiters indicate distinct data values
  • Separate data values into columns based on a delimiter
  • Split delimited values into rows
  • Test your knowledge with a quiz

Recommended Follow-Up: Sorting Data, VLookUps with Designer

This lesson is also available in: French, Spanish, Portuguese, and Japanese