Consolidate data into single rows

Hello

I have been trying to solve this for 3 days but cant get anywhere with it, the id number can be different but same value 331, 0331 but all the names are the exact same.

ID	name	website	email	Phone	package	cat_i
650	Next inc	www."".com	aa@"".com	111	TLI10	201
650	Next inc	www."".com	aa@"".com	111	AER	151
31	NEXUS	www."".com	aa@"".com	222	AER	151
031	NEXUS	www."".com	aa@"".com	222	AEC	425
031	JUST CORP	www."".com	aa@"".com	333	TLI10	201
15496	ACME inc	www."".com	aa@"".com	444	TLI10	201
15496	ACME inc	www."".com	aa@"".com	444	RMS	245
15496	ACME inc	www."".com	aa@"".com	444	AEC	425

i need to run a macro to change it to

ID	name	website	email	Phone	package	cat_i
650	Next inc	www."".com	aa@"".com	111	TLI10, AER	201,151
31	NEXUS	www."".com	aa@"".com	222	AER, AEC	151, 425
031	JUST CORP	www."".com	aa@"".com	333	TLI10	201
15496	ACME inc	www."".com	aa@"".com	444	TLI10, RMS, AEC	201, 245, 425

Please help if you can i have 18000 rows and i have been manualy doing data entry and have only got 2000 rows done this will take me weeks to do. i found the below but i can not work out how to change it to work with this.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thank you so much bob happy easter