How to repeat values in a column when they are strings
Hi everyone!
I've used this script below for numerical values
If( Is Missing( :Name( "For Calc - Data1" ) ),
Lag( :Name( "Data1" ), 1 ),
:Name( "For Calc - Data1" )
)
With the resulting table looking like this
For Calc - Data1Data11212 12 123333 33
However I can't apply this same formula to a column that has strings or characters to result in the following data table because I get an error sa...