I have created a table which contains a rownumber, memberid and Datestart,, dateEnd. The problem is that I can have duplicate memberid's. I need to interogate the date ranges on all the duplicate rows to do GAP analysis on the date ranges . I have been searching for a PIVOT example to pivit the date columns into one row.
See the attached file for the problem visual. where the row is greater than 1 I need to add the dates to the first.