Need a Way to Group in a Calculated Column Based on Another Column

[MacFletch]

I am looking for a way to group the data below by the "Channel" column in order. Here is what I have:

UniqueID	Channel	Order
123456	E	1
123456	E	2
123456	DM	3
123456	E	4
234567	DM	1
234567	DM	2
234567	E	3
345678	DM	1
345678	E	2

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

This is what the end result should look like:

UniqueID	Channel	Order	Group
123456	E	1	E|E|DM|E
123456	E	2	E|E|DM|E
123456	DM	3	E|E|DM|E
123456	E	4	E|E|DM|E
234567	DM	1	DM|DM|E
234567	DM	2	DM|DM|E
234567	E	3	DM|DM|E
345678	DM	1	DM|E
345678	E	2	DM|E

<colgroup><col span="3"><col></colgroup><tbody>
</tbody>

I tried the Jason Thomas method but kept getting an error that said "Calculation Needed".

Any help will be greatly appreciated.

 

[ImkeF]

Hi,
if you are adventurous enough, you could use PowerQuery for this task ("description" actually being your "Group"):

http://www.mrexcel.com/forum/power-bi/844631-multiple-lines-single-description.html