This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am wondering which custom Filter Formula I will need to use to say move everything that applies to that filter down one row. So for example column a is all numbers except half way through there is words - so when it sees the words I want the data to move down one row and a space to appear between the data ? Is this possible. Example how I want it to look below:
I've attached an example of how this can be done. This workflow identifies string values, and duplicates those records so they can be unioned back into the original data with empty values. The position is controlled by modifying a RecordID field.