collect cells from different cells if another cell is equal.

[orjanmen]

Hi, I got a sheet where each order are splitted into one row per item. I would like to collect all items from same order into one row - is this possible?

FROM THIS:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Order[/TD]
[TD]Item[/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]Red[/TD]
[/TR]
[TR]
[TD]4567[/TD]
[TD]Blue[/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]Yellow[/TD]
[/TR]
[TR]
[TD]4567[/TD]
[TD]Brown[/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]Orange[/TD]
[/TR]
</tbody>[/TABLE]


TO THIS:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Order[/TD]
[TD]Item[/TD]
[TD]Item2[/TD]
[TD]Item3[/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]Red[/TD]
[TD]Yellow[/TD]
[TD]Orange[/TD]
[/TR]
[TR]
[TD]4567[/TD]
[TD]Blue[/TD]
[TD]Brown[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]Yellow[/TD]
[TD]Red[/TD]
[TD]Orange[/TD]
[/TR]
[TR]
[TD]4567[/TD]
[TD]Brown[/TD]
[TD]Blue[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]Orange[/TD]
[TD]Red[/TD]
[TD]Yellow[/TD]
[/TR]
</tbody>[/TABLE]

- OR THIS -
[TABLE="width: 500"]
<tbody>[TR]
[TD]Order[/TD]
[TD]Item[/TD]
[TD]Item2[/TD]
[TD]Item3[/TD]
[/TR]
[TR]
[TD]1234[/TD]
[TD]Red[/TD]
[TD]Yellow[/TD]
[TD]Orange[/TD]
[/TR]
[TR]
[TD]4567[/TD]
[TD]Blue[/TD]
[TD]Brown[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Would love some help With this one.

 

[sheetspread]

See here:

https://www.mrexcel.com/forum/excel...-all-matches-column-up-corresponding-row.html

 

[orjanmen]

Thank you so much. Not always so easy to find something when you don't know what to search for

 

[sheetspread]

I completely understand. Like trying to find the name of this song:

https://www.youtube.com/watch?v=Fa3k1ZFo4Xc

when you only remember "woah woah woah woah...."