Analyzing data that spans over numerous rows is a complicated task even with a platform as powerful as Alteryx in your arsenal. For these tasks, you will need to understand the Multi Row Formula tool which allows for some data manipulation across multiple rows once you become familiar with the tool's functionality. See this tool in action when Data Prep U demonstrates how to clean up messy Excel worksheets using the Multi Row Formula tool.
