How to Concatenate start and last values of Rows based on Breaking of Sequence

[iamalone]

Hi,

I have some names in "Col A" and have some years with respect to "col A" in 'Col B".So from this,
i need to concatenate years which in "col B" based on sequence w.r.t unique data in "Col A".


For Eg: Peter Simpson 2004
Peter Simpson 2005
Peter Simpson 2006
Alsup 2001
Alsup 2003
Saint Foyt 1979
Saint Foyt 1980
Saint Foyt 1981
Saint Foyt 1983
Mark Luberg 1983
Mark Luberg 1984
Mark Luberg 1986
Mark Luberg 1987
Mark Luberg 1988
Mark Luberg 1990

like this i have some 10000 records. so i want o/p to display years which are in sequence for data in "col A"
as 2004-2006 and those years which are not in sequence kept them in separate columns.


Finally o/p has to be like this------ Peter Simpson 2004-2006
Alsup 2001 2003
Saint Foyt 1979-1981 1983
Mark Luberg 1983-1984 1986-1988 1990



can anyone give me ideas?

[:) Sixthsense :)]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[iamalone]

kk thanks for responding...Here i am attaching sample sheet, in that output i want data for first unique columns only...for all remaining duplicates it has to be blank.

Thanks