Split Columns

Use Split Column when one column contains multiple pieces of information.

Example:

Amit-Sirsa

Split by delimiter -:

Name	City
Amit	Sirsa

Merge Columns

Combine columns into one.

Example:

First Name	Last Name
Amit	Kumar

Result:

Amit Kumar

Fill Down

Useful when a category appears only once and blank cells follow it.

Example:

Category
Electronics
null
null
Accessories

Fill Down produces:

Category
Electronics
Electronics
Electronics
Accessories

Fill Up

Fill missing values using the value below.

Practice

Clean a customer dataset containing:

• Combined Name-City values
• Blank category cells
• Separate first and last names