combine almost identical rows into one by concatenating unique values

[teresadg]

Hi,

I hope someone could help me with sorting this table out thru vba:

Item#	Desc1	Desc2...	Descx (columns can run longer)
C1	red	long	thin
C2	blue	short	thick
C3	red	long	thin
C4	blue	short	thick
C5	yellow	med	med
Cy	blue	short	thick

<colgroup><col style="width:48pt" width="64" span="4"> </colgroup><tbody>
</tbody>

(rows can run longer)

Resulting table should be:

Item# Desc1 Desc2... Descx C1, C3 red long thin C2, C4, Cy blue short thick C5 yellow med med <colgroup><col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:3437;width:71pt" width="94"> </colgroup><tbody> </tbody> Basically, rows with the same content from column 2 to x, is combined and the first cell in such rows is concatenated (separated by comma). Thanks for taking the time out to help. Regards teresadg <colgroup><col style="mso-width-source:userset;mso-width-alt:3291;width:68pt" width="90"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:3437;width:71pt" width="94"> </colgroup><tbody> </tbody> <colgroup><col style="mso-width-source:userset;mso-width-alt:2413;width:50pt" width="66"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:3437;width:71pt" width="94"> </colgroup><tbody> </tbody>

<colgroup><col style="width:48pt" width="64" span="3"> <col style="mso-width-source:userset;mso-width-alt:3437;width:71pt" width="94"> </colgroup><tbody>
</tbody>

 

[teresadg]

Re-posting the desired outcome (sorry for the earlier post)...

Item#	Desc1	Desc2...	Descx
C1, C3	red	long	thin
C2, C4, Cy	blue	short	thick
C5	yellow	med	med

<colgroup><col style="mso-width-source:userset;mso-width-alt:3986;width:82pt" width="109"> <col style="width:48pt" width="64" span="2"> <col style="mso-width-source:userset;mso-width-alt:3437;width:71pt" width="94"> </colgroup><tbody>
</tbody>

Basically, rows with the same content from column 2 to x, is combined and the first cell in such rows is concatenated (separated by comma).

Thanks for taking the time out to help.

teresadg