Grouping cells in Excel

[Domo]

I need to group some cells in excel. It's a csv file and this exercise is required to clean the data up prior to import.

Column 1 contains the unique ID each record should be grouped by. Most rows contain replicated data in each column but some columns contain data which has to be merged into one cell.

Eg one record looks like this

a,b,c,d,
1 ID1,London,red,colour
2 ID1,London,yellow,colour
3 ID1,London,green,colour
4 ID1,London,blue,colour

So this should be one record, with the different colours grouped into one cell. There are approx 10 columns, of which 2 or 3 require grouping.

I hope this makes sense to someone out there!

 

[jamesy505]

Not sure what you mean, but would concatenate not work?

 

[Domo]

Referencing my example, the record would read:

a,b,c,d,
1 ID1,London,red yellow green red,colour

So yes, concatenate would work (thanks!) but for the cream as well as the cake I want carriage returns so each colour is on a new line but within the cell.
I tried using CHR(10) but that didn't work

 

[izzop]

Referencing my example, the record would read:

a,b,c,d,
1 ID1,London,red yellow green red,colour

So yes, concatenate would work (thanks!) but for the cream as well as the cake I want carriage returns so each colour is on a new line but within the cell.
I tried using CHR(10) but that didn't work

Try it with CHR(13) this is Carriage Return, CHR(10) is New Line although I'm not sure if it will work.

Regards