I have been looking through and trying to figure it out but need some help. I have a bunch of data and each row has a 4 date fields. The first date field is a duplicate for the ID number and sometimes not. It looks a little like this: I would like to clean it up to combine them into one row for each ID number. It would look like this: I tried the pivot method but it didn't work because of my duplicate values in the first two sets of dates. Anyone have any insight into what could make this work? Continue reading...
