cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
Yngeinstn
Level IV

Fill in Missing Data Based on previous column [cell] value

I apologize for this redundant question about column fill but for the life of me i can't find any of the previous topics.

 

I have a data table that is filled out in an incomplete manner. I need to fill the missing cells below each value with its predecessor. I know it is a Column Formula script that uses the Lag() and Row() but can't find the correct syntax.

 

 

Yngeinstn_0-1616160792125.png

 

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Fill in Missing Data Based on previous column [cell] value

@julian has the perfect answer here... if a picture is worth 1000 words, a .gif is worth 1e6.

 

https://community.jmp.com/t5/Discussions/Fill-consecutive-rows/m-p/366760

 

View solution in original post

1 REPLY 1

Re: Fill in Missing Data Based on previous column [cell] value

@julian has the perfect answer here... if a picture is worth 1000 words, a .gif is worth 1e6.

 

https://community.jmp.com/t5/Discussions/Fill-consecutive-rows/m-p/366760