I am using Excel 2007. My data consists of rows with identical information
except for date values. I want to concatenate the rows into a single row so
that I can see, along with the other information, the date values in the
single row. Here is an example:

MemberID DataDate
16 6/18/2009
16 3/26/2009


Here is the desired format:

Member ID DataDate1 DataDate2
16 3/26/2009 6/18/2009

Is this possible with Excel '07?