Any help would be greatly appreciated

Question

Hello Alteryx Community!

I am having trouble making a workflow that can achieve my desired result. I have uploaded a Raw Data Example and a tab of what I hope the results will look like (Desired Result tab).

Any help would be much appreciated!!! I have been spending a while working on this and have not gotten anywhere :(

Thanks again in advance!

Raw Data.xlsx

caltang · Answer

Didn't you post this already? https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Cleaning-Tiered-Data/m-p/1197478#M297021

I've cleansed your data accordingly there. You have to state your requirements more clearly - which rows of data are required?

For Msleepy.yxzp

Paridhi_Agrawal · Answer

I tried to build a workflow, have a look.

New Workflow-13Oct.yxzp