Multi Row Formula Tool - Multiple Columns

[cjmason105]

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.

[Luke_C]

Hi @cjmason105 

Maybe @patrick_digan 's macro can help: https://community.alteryx.com/t5/Engine-Works/Step-Through-the-Multi-Verse/ba-p/903462

[Qiu · Accepted solution]

@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.

[cjmason105]

Sorry for the delayed response but this is exactly what I needed.  Thank you so much!

[Qiu]

@cjmason105 
Thank you for the feedback and I am happy it is helpful.