Join data points across multiple columns and insert characters between each entry
Automatically remove extra spaces from data points using the Find/Replace object
Clean phone numbers of unwanted characters, such as parentheses or plus signs
Find the Min or Max of a data set to quickly summarize large reports
Use if/else logic to automatically apply data labels or filter out new data as it comes in
Remove duplicate rows from a table based on criteria that you supply. Choose how many duplicates to keep or merge duplicates.
Combine two data sets by matching across multiple columns for a more accurate join.
Add a column to a table that sums all of the numerical cells in the same row. Useful for tabulating sales numbers or creating a balance sheet.
Score prioritize and dedupe leads based on your own criteria to make sure you only get in contact with the highest probability leads at a given company.
Add data to your dataset by pulling in additional data from an external data source.
Compare two lists and remove data from the first that exists in the second in order to prevent overlapping data.