Thursday, February 27, 2020
Use PowerQuery to Change the Order of Cell Values or Text
If you've tried to rearrange the order of text or data in cells within Excel, you're probably familiar with the LEFT, MID and RIGHT functions. The combination of these functions help you reverse text or first and last names. You can rearrange the data of almost any kind of content in your cells with these function. Incidentally there are formulas in the Power Query M code that can do the same thing and this video will cover two examples.
Thursday, February 20, 2020
Generate Random Numbers in Power Query
Want to create random numbers in Excel? If you're familiar with RAND and the RANDBETWEEN functions, did you know there was an equivalent in Power Query where you can create a list of random numbers in each row. There's no command icon to click in Power Query, so you'll have to go into the M language (but it's fairly easy).
Tuesday, February 18, 2020
Combine Text into a One Cell Comma Separated List [2 Examples]
If you worked in an Enterprise business environment, you may have come across the scenario where you need to take a list of data from one system for input into another. However the list from the first system is in one column (row by row). You need to put this list as a delimited list (separate by commas) into another system. How are you going to do this? Well...of course with Excel! And I'll show you two ways you can do this so check out the video!
Subscribe to:
Posts (Atom)