Create All Possible Combinations from Two or More Lists in Power Query

If you have two or more list and wanted to figure out all the possible combinations of the items of those list, it would be called a cross join, many to many join or a cartesian join. This can actually be done easily with Power Query. It shouldn't take too long if your source list are small. But if your list are bigger, you could potentially have output that could be a table of several million rows or records. If you know Excel, it does support 1M+ records in a single worksheet, but not over 2 million records. An example in this video will cover 4M+ records but the workaround is to separate the records into a million each and put all of it into a text file. See the video to learn how generate all possible combinations from two or more list.via IFTTT

Keyword Search in Two Columns with Power Query

If you have user that want you make an easier keyword lookup for a table of records, you could tell them to just filter the table or put some lookup formula (like VLOOKUP) together for them. But if they just want some easy to use field where they type up something and click here to get the results, maybe another solution would be to use Power Query. But remember to tell them that this is a case sensitive keyword search!

Split Records into Columns or Rows with Power Query

Have you ever received a table of data that is packed into one cell and you needed to split the records into multiple columns or multiple rows. The records from the original table may have commas or line breaks as the delimiter and you think there should be some delimiter function or formula that takes care of this. In this video, I'll show how it can be done using Power Query. There are two examples with both showing how to split a multiline cell into new rows or columns.

For those that don't have Power Query, there is the option of using the text to columns function in Excel and that video is at https://www.youtube.com/watch?v=cOfaYdL55AE&t=65s