I have a data set that where I need to combnine several rows into one. See below ID Date Var1 var2 var3 1 7/4/17 1 . . 1 7/4/17 . 0 . 1 7/4/17 . . 1 1 5/4/17 0 . . 1 5/4/17 . 0 . 1 5/4/17 . . 0 2 6/4/17 . 1 . 2 6/4/17 0 . . 2 6/4/17 . . 1 3 7/14/17 0 . . 3 7/14/17 . 0 . 3 7/14/17 . . 1 The desired outcome would be a single row per ID. Note - There are some ID that have data from an additional date. I need both. ID Date Var1 Var2 Var3 1 7/4/17 1 0 1 1 5/4/17 0 0 0 2 6/4/17 0 1 1 3 7/14/17 0 0 1 Thank you for any help and input
... View more