Hey Alteryx-Community,
I'm trying to clean up a list of music performances that I'd like to add to an Alteryx workflow. I am trying to come up with a workflow that appends the information contained in column A to all empty cells up until the next filled cell and then divide the amount that's listed in column E by the total number of performances for that song, so that each line has the correct corresponding amonut next to it. After that i could just filter out all lines that are empty in column B and have a functioning csv, finally.
I feel like this is probably a quick and easy solution but I can't seem to get there. I'd be immensely grateful for some assistance.
Many thanks and all the best,
Matthias
