I have a data set that looks like this ID, Provider, Appt Date, Patient, Note Date, Notes, etc… Code:1234, Dr. Jones, 12/19/2006, John Q Public, 12/18/2006, Mr Public … 1234, Dr. Jones, 12/19/2006, John Q Public, 12/19/2006, Patient looked fine… 1234, Dr. Jones, 12/19/2006, John Q Public, 12/22/2006, Lab results came in … I want the report to look like this … 1234, Dr. Jones, 12/19/2006, John Q Public, 12/18/2006, Mr Public … 12/19/2006, Patient looked fine… 12/22/2006, Lab results came in …I’ve got a grouping so that all the 1234 records are together and separated but I’d like to remove the duplicative data resulting from the join in the first 4 columns. Thanks in advance, Chad
