Skip to Main Content
Microsoft Excel 365 Bible
book

Microsoft Excel 365 Bible

by Michael Alexander, Dick Kusleika
March 2022
Beginner to intermediate content levelBeginner to intermediate
1072 pages
28h 16m
English
Wiley
Content preview from Microsoft Excel 365 Bible

CHAPTER 36Transforming Data with Power Query

Data transformation generally entails certain actions that are meant to “clean” your data—actions such as establishing a table structure, removing duplicates, cleaning text, removing blanks, and even adding your own calculations.

In this chapter, you will be introduced to some of the tools and techniques in Power Query that make it easy for you to clean and massage your data.

Performing Common Transformation Tasks

You will find that many of the unpolished data sets that come to you will require various types of transformation actions. The following sections cover some of the more common transformation tasks that you will have to perform.

Removing duplicate records

Duplicate records are absolute analysis killers. The effect that ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Excel 2019 Bible

Excel 2019 Bible

Michael Alexander, Richard Kusleika, John Walkenbach

Publisher Resources

ISBN: 9781119835103Purchase Link