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
Subscribe to:
Posts (Atom)