Hello,
I am hoping someone has a solution for this. I have pricing information over time for multiple items. Is there a way to replace future data (nulls) with the last value? I would like a solution that if I add new columns the formula would apply to them as well.
Solved! Go to Solution.
Hi @cjmason105
Maybe @patrick_digan 's macro can help: https://community.alteryx.com/t5/Engine-Works/Step-Through-the-Multi-Verse/ba-p/903462
@cjmason105
There is a typical use case of Cross Tab and Transpose if I understand your intention correctly.
We use Transpose to bring multiple columns in to one then process, at the last use Cross Tab to restore the data structure.
Sorry for the delayed response but this is exactly what I needed. Thank you so much!
@cjmason105
Thank you for the feedback and I am happy it is helpful.