concatenate options (orientation) within summarize tool

sammyb84

Hi I'm needing to group a column based on group by from another column.  I have a list of stores that need to be grouped by their products they have.

I am trying to send each of these stores their current list of products in an email.  I'm aware of using the Report text tool to help with these and change dynamically the list of products.  

However I need to change the orientation of the product list so it looks cleaner.  I do not want to create a new row for each product because that would defeat the purpose of summarizing.  

Need to know if something can be done within Summarize tool, Formula Tool or Report Text tool.  

Instead of :

Store 1  |   Apples, Pears, Potatoes, Rice, Celery.

Store 2  |   Chicken, Rice, Potatoes

I would like

Store 1 | Apples

              Pears

              Potatoes

              Rice

              Celery

Store 2 | Chicken

               Rice

               Potatoes

Thanks for your help

Luke_C

Hi @sammyb84 

Not sure how the original data looks, but here's an example:

1. Group by store, concatenate using the \n delimiter to create the newlines
2. Prepend the store to the concatenated field

New Workflow2.yxmd