I am looking for a way to group the data below by the "Channel" column in order. Here is what I have:
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
This is what the end result should look like:
<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.
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.