Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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
ChristineB
Alteryx Alumni (Retired)
Created

 

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

Description:  

  • 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