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

Keyword Lookup 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!