From the course: Excel Power Query Tips and Techniques
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Warning: Two types of merges
From the course: Excel Power Query Tips and Techniques
Warning: Two types of merges
- [Instructor] Here's a members list and somehow, the names of the cities have flown apart on us like Salt Lake City, The Hague. They need to be brought together. And then we also want to put the age, favorite color, and active or not all together. We're going to do this in Power Query and I'm going to show you some gotchas that you got to look out for. Okay, here we go. Data, from table slash range. Okay. So the first thing we want to do is put the city names together. I'm going to highlight city, hold on the control key, then column one, then column two. Add column, merge columns. Separator, I want a space and call this cities. Okay. There is my cities column. Now here's another way of merging columns that's very different from what we just did. I'm going to highlight age, hold on the control key, favorite color, active. Right click, merge columns. Let's put a custom, we're going to put comma, space,…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
(Locked)
Filtering in Power Query2m 30s
-
(Locked)
Sorting in Power Query1m 17s
-
(Locked)
Pass parameter: Drill down to a single value2m 59s
-
(Locked)
Prevent table from resizing1m 12s
-
(Locked)
Transformation table2m 48s
-
(Locked)
Filter for certain files when importing from a folder2m 11s
-
(Locked)
Warning: Two types of merges3m 18s
-
(Locked)
Splitting columns1m 14s
-
(Locked)