put categories into the same cell with delimiter

[#1]

Hi, I'm in tabulate and has the below table:

Screen Shot 2021-10-18 at 1.09.02 PM.png

Is there a way i can make the channel into one cell using existing function, not script?  like:

Screen Shot 2021-10-18 at 1.09.59 PM.png

Thanks in advance!

[#2]

The only way I know how to do this, would be to use the Summary platform to aggregate the statistics, and then to use the Split platform to create different columns for the Direct and Trade data and then to create new columns to sum the counts and to concatenate the 2 Channels.  Finally, you can then take the modified data table and use the Tabulate platform to display the results. 

[#3]

Thank you Jim! I'm stuck in the split step you mentioned- how did we get the direct trade in the right place to concatenate while having the numbers in the cells?

Screen Shot 2021-10-19 at 3.56.40 PM.png

[#4]

Take the split table you have created and create 2 new columns.

1. Create column called Channel
   1. Give it the formula

      Char( Column( 2 ) << get name ) || "_" || Char( Column( 3 ) << get name )

2. Create a column called N Rows
   1. Give it the formula

      :DIRECT + :TRADE

3. It gives you the following data tabletxnelson_0-1634674770654.png
4. Now use the Tabulate platform to create the Display output you want                                                  txnelson_1-1634674860467.png