Macro to merge rows in one column based on value in another column that has been sorted

[sewed]

I'm trying to enhance another macro i have that will go through several steps to resort rows. I now want vba code to add a column that merges all the rows associated with values that have been sorted in another column.

Below is an example of the current data structure looks like (not real data) and what i would like it to look like including formatting (see hyperlink).

Thanks in advance.

Current
	#	CODEII	SEQ	LINE Number	Directions	Start	Finish
	1	Red	116330	1	AB	8/1/2013	9/1/2014
	2	Red	116330	2	ABC	8/1/2013	9/1/2014
	3	Blue	116330	3	AB	8/1/2013	9/1/2014
	4	Orange	116330	4	ABCDE	8/1/2013	9/1/2014
	5	Yellow	114103	1	ABC	8/1/2013	9/1/2014
	6	Yellow	114103	2	AB	8/1/2013	9/1/2014
	7	Red	114103	3	ABCDE	1/1/2014	3/1/2014
	8	Purple	114103	4	ABCDE	8/1/2013	9/1/2014
	9	Blue	114103	5	ABC	8/1/2013	9/1/2014
	10	Blue	112868	1	3ABZBC	8/1/2013	9/1/2014
	11	Yellow	112868	2	3ABZBC	8/1/2013	9/1/2014
	12	Orange	112868	3	ABC	8/1/2013	9/1/2014
	13	Red	112868	4	ABC	1/1/2014	3/1/2014
	14	Green	112868	5	ABC	1/1/2014	3/1/2014
	15	Green	115981	1	AB	1/1/2014	3/1/2014
	16	Green	115981	2	AB	1/1/2014	3/1/2014
	17	Blue	115981	3	ABC	8/1/2013	3/2/2014
	18	Yellow	115981	4	AB	8/1/2013	3/2/2014
	19	Orange	115981	5	ABCDE	8/1/2013	3/2/2014

<tbody>
</tbody>

Here is what i would like it to look like: https://www.dropbox.com/s/xc0kkj4meptbci8/vba.png?dl=0

<tbody>
</tbody>

 

[sewed]

bumb