Part V: Understanding Power Pivot and Power Query
FIGURE 39.6
Merging the Type and Code fields
FIGURE 39.7
The Merge Columns dialog box
The reward for your efforts will be a new field containing the concatenated values from
original column (see Figure 39.8).
This is nifty, but you will notice that Power Query removes the original Type and Code
columns. There will definitely be instances when you want to concatenate values but still
retain the source columns. In those instances, the answer is to create your own custom
column. Later in this chapter, you’ll discover how to use custom columns to solve this and
other transformation problems.
