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).

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!

Power Query - Create a Table that References Itself After an Update

There may be a time when you want to make an addition (like add a column) to your output table from Power Query and have that update show up in the right place. It becomes a query that takes its output as its new input, appends the new data and overwrites the old result with the new one. This can be called (or at least the concepts are similar to) a self referencing query, circular reference, recursive table, self join or self referencing table. Though it sounds complicated, the steps to do this are quite simple.