Replace blank columns with the next non-blank value

[janani_venkat]

Hi All,

Attached is a sample excel data along with how I need this manipulated in Alteryx - can you please give me an idea on how I can achieve this? 

The data that I have only has details at total level but I need this to repeat every line (similar to "repeat line" option in excel pivot). Can you please help?

Thanks,

Jan

[clmc9601 · Accepted solution]

Hi @janani_venkat,

Would this work?

 I hope it helps!

[janani_venkat]

@clmc9601 This is perfect - I just had to make some tiny tweaks but this gave me the idea! Thank you so much!!! Appreciate your help

Jan