Excel 2019 Bible

Chapter 39: Transforming Data with Power Query 39 FIGURE 39.2 Removing duplicate records If you made a mistake and removed dupli ...

Part V: Understanding Power Pivot and Power Query Filling in blank fields It’s important to note that there are actually two kin ...

Chapter 39: Transforming Data with Power Query 39 FIGURE 39.5 Replacing empty strings with the word Undefined We can do so by ri ...

Part V: Understanding Power Pivot and Power Query FIGURE 39.6 Merging the Type and Code fields FIGURE 39.7 The Merge Columns dia ...

Chapter 39: Transforming Data with Power Query 39 FIGURE 39.8 The original columns are removed and replaced with a new merged co ...

Part V: Understanding Power Pivot and Power Query infringement on your company’s trademarked name, and it must be changed to Bou ...

Chapter 39: Transforming Data with Power Query 39 FIGURE 39.11 Leading spaces can cause issues in analysis. This is intended to ...

Part V: Understanding Power Pivot and Power Query systems. These characters are typically rendered in Excel as a question mark o ...

Chapter 39: Transforming Data with Power Query 39 FIGURE 39.13 The Extract command allows you to pull out parts of the text foun ...

Part V: Understanding Power Pivot and Power Query FIGURE 39.14 Extracting the first three characters of the Phone field To extra ...

Chapter 39: Transforming Data with Power Query 39 FIGURE 39.15 Extracting the two middle characters of the SicCode FIGURE 39.16 ...

Part V: Understanding Power Pivot and Power Query By Number of Characters Allows you to split a column based on a specified numb ...

Chapter 39: Transforming Data with Power Query 39 Figure 39.18 demonstrates the new columns created after the ContactName column ...

Part V: Understanding Power Pivot and Power Query Power Pivot offers an easy way to unpivot and pivot columns, allowing you to c ...

Chapter 39: Transforming Data with Power Query 39 command. This nifty command allows you to unpivot by selecting the columns you ...

Part V: Understanding Power Pivot and Power Query FIGURE 39.22 Pivoting the Month and Revenue columns Before finalizing the pivo ...

Chapter 39: Transforming Data with Power Query 39 Creating Custom Columns When transforming your data, you’ll sometimes have to ...

Part V: Understanding Power Pivot and Power Query As for the Custom Column dialog box, there’s not much to it. The points of inp ...

Chapter 39: Transforming Data with Power Query 39 In these instances, you can create your own custom column. Follow these steps ...

Part V: Understanding Power Pivot and Power Query FIGURE 39.26 A formula to merge the Type and Code columns TABLE 39.1 Common Co ...