I have a spreadsheet with 6 columns and thousands of rows. The first
column is the id

Example of the data (6 columns)-
04731 CRM 2 EX 97 01
04731 CRM 5 LX2WD 97 01
04731 CRM 5 LX4WA 97 01
04731 RVB 5 LX4WD 91 95
04731 RVB 5 SE 91 95
25475 MMX 2 FR 95 96
25475 MMX 5 GR 96 97


Result desired (2 columns)-

04731 CRM 2 EX, 5 LX2WD, LX4WA 97 01; RVB 5 LX4WD SE 91 95
25475 MMX 2 FR 95 96, 5 GR 96 97

Idea is to summarize the data of 5 columns in 1 column and eliminate
the duplicates

Any help is greatly appreciated.

Thanks !!!