Formula to Group Duplicate Cells/Data into Single Cell (Not VBA)

[HeyItsDizzy]

Hey Guys Just after some heap been rcking my brain for days!

My Table/Range has been pupulated this way;
[TABLE="width: 626"]
<tbody>[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]Window Support Channel
[/TD]
[TD]1/1800, 1/1200, 3/600,
[/TD]
[/TR]
[TR]
[TD]Window Support Channel
[/TD]
[TD]4/1800, 2/1200, 4/900,
[/TD]
[/TR]
[TR]
[TD]Window Support Channel
[/TD]
[TD]1/1800, 1/1200, 3/600,
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

I am trying to create another table, where I can read this Range and pupulate it this way;
[TABLE="width: 500"]
<tbody>[TR]
[TD]Window Support Channel[/TD]
[TD]1/1800, 1/1200, 3/600, 4/1800, 2/1200, 4/900, 1/1800, 1/1200, 3/600,[/TD]
[/TR]
</tbody>[/TABLE]

And since I made that, I have also noticed noticed Duplicates, therfore is it also possible to take it further and make my table read this way;
[TABLE="width: 500"]
<tbody>[TR]
[TD]Window Support Channel[/TD]
[TD]6/1800, 4/1200, 6/600, 4/900[/TD]
[/TR]
</tbody>[/TABLE]

Note: the "1800,1200,900,600" can be any length I have just used these sizes as reference


Thanks in Advance

 

[Peter_SSs]

is that what you want?

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]Item[/td][td=bgcolor:#5B9BD5]Value[/td][td][/td][td=bgcolor:#70AD47]Item[/td][td=bgcolor:#70AD47]Value[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Window Support Channel[/td][td=bgcolor:#DDEBF7]1/1800, 1/1200, 3/600,[/td][td][/td][td=bgcolor:#E2EFDA]Window Support Channel[/td][td=bgcolor:#E2EFDA]1/1800, 1/1200, 3/600,4/1800, 2/1200, 4/900,[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Window Support Channel[/td][td]4/1800, 2/1200, 4/900,[/td][td][/td][td][/td][td][/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Window Support Channel[/td][td=bgcolor:#DDEBF7]1/1800, 1/1200, 3/600,[/td][td][/td][td][/td][td][/td][/tr]
[/table]

Yes that is correct

But the above is not like either of your requested results.
It neither lists all 9 results like the first request, nor combines the like terms as in your modified request.
Can you clarify further about that?

I am trying to create another table, where I can read this Range and pupulate it this way;
[TABLE="width: 500"]
<tbody>[TR]
[TD]Window Support Channel[/TD]
[TD]1/1800, 1/1200, 3/600, 4/1800, 2/1200, 4/900, 1/1800, 1/1200, 3/600,[/TD]
[/TR]
</tbody>[/TABLE]

And since I made that, I have also noticed noticed Duplicates, therfore is it also possible to take it further and make my table read this way;
[TABLE="width: 500"]
<tbody>[TR]
[TD]Window Support Channel[/TD]
[TD]6/1800, 4/1200, 6/600, 4/900[/TD]
[/TR]
</tbody>[/TABLE]