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;

Window Support Channel 1/1800, 1/1200, 3/600, Window Support Channel 4/1800, 2/1200, 4/900, Window Support Channel 1/1800, 1/1200, 3/600, <tbody> </tbody>

<tbody>
</tbody>

I am trying to create another table, where I can read this Range and pupulate it this way;

Window Support Channel

1/1800, 1/1200, 3/600, 4/1800, 2/1200, 4/900, 1/1800, 1/1200, 3/600,

<tbody>
</tbody>

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;

Window Support Channel

6/1800, 4/1200, 6/600, 4/900

<tbody>
</tbody>

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?

Item	Value		Item	Value
Window Support Channel	1/1800, 1/1200, 3/600,		Window Support Channel	1/1800, 1/1200, 3/600,4/1800, 2/1200, 4/900,
Window Support Channel	4/1800, 2/1200, 4/900,
Window Support Channel	1/1800, 1/1200, 3/600,

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;

Window Support Channel

1/1800, 1/1200, 3/600, 4/1800, 2/1200, 4/900, 1/1800, 1/1200, 3/600,

<tbody>
</tbody>

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;

Window Support Channel

6/1800, 4/1200, 6/600, 4/900

<tbody>
</tbody>