Cleaning up csv

[MatthiasBE]

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

[DataNath · Accepted solution]

Hey @MatthiasBE, how does this look? Let me know if there's any issues! One thing I can think of right away is that you may want to change the rounding of the amounts, depending on the level of precision desired.

[DavidSkaife · Accepted solution]

Hi @MatthiasBE 

Here is one way of doing it:

[MatthiasBE]

Legend! Thank you so much, David! Exactly what I needed

[MatthiasBE]

Works perfectly! And I learned something from this, thanks for your help, mate.