Attempting to flatten multiple temporal data points for single identifier

Originally Posted by cranialnerve

thanks for your help! I am wondering, however, will this equation work for a data set involving 500+ patients? Like an apply automatically to entire sheet method?

Nevermind, I gave this a try and it works great. Thanks!