Power Tools for google sheets

Power Tools add-on cuts the clicks on repeated tasks and brings features for organizing and unifying data in Google Sheets.

Extra spaces, formulas and data in the wrong format are among many of the issues the add-on deals with:

• Take advantage of the new smart toolbar with handy assistants: change case, flip values, calculations based on color, unpivot table, unmerge all cells on the sheet in a click.
• Click once to AutoSum numbers in every row or column; sum and count cells by color.
• Search all selected sheets for certain values, formulas, notes, and hyperlinks; see a list of found entries, export or replace them in a click.
• Get "Text to columns" feature: split values in a column by any delimiter, string, or by position.
• Automate some routine tasks: add or remove text by position, transform formulas, change formula reference type, export range to XML or JSON.
• Bring order to your sheet: delete unwanted characters, types of data, and clean up formatting.
• Get every needed data tool in one place: remove duplicates or bring them to one row, compare and merge sheets, randomize data, and much more.