If you’re familiar with Pivot Tables in Excel, there’s a pivot feature in Power Query. Why would you want to use this feature in Power Query? Well, if it something you need to need as part of you transformation steps in Power Query then you need to know it’s there. Or if it’s a step you do on a recurring basis, Power Query makes it easier to do it with a few clicks.
Monday, December 5, 2022
Monday, November 28, 2022
Fuzzy Match Lookup in Power Query
If you’re familiar with doing a lookup in Power Query, it’s basically using the Merge feature. Inside this merge feature is a almost hidden option of using something called Fuzzy match.
If you’re used to doing lookups in Excel with VLOOKUP or INDEX/MATCH, you know that it does an exact match with the looked up text or value. What Fuzzy match does for your is to try to “guess” your looked up value and bring back your intended results. It’s neat that it would guess this and in some case with the help it can look up MSFT and bring back data associated with Microsoft (all spelled out).
Monday, November 21, 2022
Transpose One Column Into Multiple Columns with Excel Macro
Say you’ve got a file from someone that is an address list. Name, address, city etc. But it’s all in one column. It’s not separated into different columns to easily do any analysis or mail merge. You need to put it into a table with a name field or address field. This also can apply to other types of one column data or databases.
There’s a bunch of ways to transform this type of data, and in this video, I’ll show a quick way to do it by recording a macro. It’s not as scary as it sounds. Heck I’m not VBA expert and I could even do it. And if I can do it, so can you.
Subscribe to:
Posts (Atom)