If you have to merge two repeated measures data sets, each with missing data, use a “true timeline” data set as the core data to merge into.
Excel => First date => (function above cell + 1) => Format cells => as xx/yy/zz => as character in R.
Bo\(^2\)m =)