Hiii, am trying to build a workflow that can achieve the specified results from a sample set of data as seen in the excel file attached. Have been stuck for a while, please help!
@Erikalee This thread may be useful to you. @caltang is a good resource to help with these types of input files: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Cleaning-Tiered-Data/m-p/11974....
@Erikalee maybe this can help you as a start