Merging Consecutive Rows with Numerous NA Values in R using tidyr and dplyr Packages

Comparison of Dataframe Rows and Creation of New Column Based on Column B Values