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.
You may be able to do something like the workflow I've attached. What the workflow does is that it transposes the data so that all the records are in one column, then it applies the multi-row formula tool on that one column, and finally cross tabs the data back into its original format.
Let me know if you have any questions about the workflow or if it is not doing what you intend it to do.
It's still a work in progress, but perhaps it will help in your case! Wherever you save the yxzp, it will save a helpful word doc in one of the external folders. I'v attached the word doc and the full yxzp. Here is the link:
After a long week of checking and changing things I have realised that the first solution presented does work for me - it was in fact, the Excel spreadsheet I was trying to replicate in Alteryx that had cells copied across incorrectly. This was therefore why I was getting a difference in values between the two!
Thank you so much everyone for your help and solutions, the Alteryx community has really helped me with this issue.