Concat and summarize 6 columns to 2 columns

I

italia

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 !!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel code convert to Access code - Concat & eliminate duplicates 1
Concat values in two or more rows based on id and eliminate duplicates 2
Excel code convert to Access code - Concat & eliminate duplicates 2
Help Please 8
Insert rows by group and copy value 2
VLOOKUP and Return Last 2 Values 5
Open a GroupWise .NAB File 6
rows to columns 1

Top