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 have an excel file that looks like this and I want to carry the data down as the red arrows show. I know how to write and if then formula in excel to quickly do this but would like to automate in an Alteryx workflow - any ideas on the most efficient way to do so? Thanks!
Don't suppose you know how to fill up rather than down? I tired by changing Row-1 to Row+1 but the problem is the next value above could be many rows above so only the first row above gets populated. If I feed the output back in and effectively loop it, it will eventually fill them all in, but obviously that isn't very efficient!