12. Q&A - Filtering and Formatting Columns

 
Subtitles Enabled

Sign up for a free trial to access more free content.

Free trial

Overview

This lesson will review information around filtering columns, splitting columns, and the find and replace function.

Summary

Content reviewed in this lesson

  • Question 1: How do I filter a field by values?
  • Question 2: How do I split columns?
  • Question 3: How do I find and replace values?

Transcript

Filtering a field by values is quite straight forward. Select the arrow by the column name, and check or uncheck boxes as needed to see the values that you are interested in. Always make sure to click load more, so that all of the values found in the column are visible.

To split columns navigate to the home tab and select split columns.

You can split by delimiter, or split by a number of characters.

In this case we'll split by delimiter. We can select the delimiter from a drop down or assign any character of our own, however power query usually selects an appropriate delimiter automatically. You can then select to split every time a delimiter occurs, or just the first or last occurrence of the delimiter. If we press okay, we can see this date column has been split into three new columns.

In order to find and replace values, first select the column where you want to replace the values then navigate to the transform tab and select replace values.

Specify the value to be replaced and the value to replace it with.

Select okay and the column updates.