Search This Blog

Wednesday, November 11, 2020

Google Sheets - Covert Columns or Rows into Comma Separated Values


Been in a situation where you had to convert values in columns or rows into comma separated values (csv)? Maybe you got a column of value and you needed to query it in another system, BUT that system needed the input values separated by commas (or semicolons). Using Google sheets, there are actually a couple of ways you can do this and I'll show three examples with three different functions to make it happen.

Monday, November 9, 2020

Animate a PPT with the Zoom Feature


Been in a situation where you had to convert values in columns or rows into comma separated values (csv)? Maybe you got a column of value and you needed to query it in another system, BUT that system needed the input values separated by commas (or semicolons). Using Google sheets, there are actually a couple of ways you can do this and I'll show three examples with three different functions to make it happen.

Monday, November 2, 2020

Perform an Approximate Match in Power Query


If you're familiar with doing an approximate match with VLOOKUP or INDEX / MATCH, you know that it returns the next largest match that is less than the specific looked up value. Some called this a fuzzy match, but it's basically the closest match you can find. You might be wondering why you'd want to do this in Power Query when the lookup function mentioned above can do the job. Power Query may work better when you find yourself doing these kind of fuzzy lookups on a recurring basis or this step is part of a larger series of steps when you have a large dataset (over 500K records maybe?). This video will show how to replicate a VLOOKUP or INDEX/MATCH approximate match.