Create a new column based on the table

[howyoudoing]

Hi All! Based on the table I need to have these information from column VenueGatewaysName in the body of the emails under Gateways:

Could you please help me? It only takes the first one. The emails are seperated due to the VenueCptyLei and VenueSalesName so there will be 4 different emails but I want to have all VenueGatewayName under Gateways like in the first emails there are 2 of them missing - SYD_RATES_BLOOMBERG_AURATES and TRADEWEB_AU. Second email is correct, next also and in the last one to Matteo it only shows LDN_EMCREDIT_TRADEWEB_EUGV and this is missing - LDN_RATES_TRADEWEB_EUGV. 

[binuacs]

@howyoudoing one way of doing this

[howyoudoing]

Amazing! thank you! Have 1 more question regarding this, because I see on your screen that the Gateways are one by one and I have all next to each other in one line, could you please help me how to have them all one under the other just like you have in your screen?

[DavidSkaife]

Hi @howyoudoing 

When you concatenate in the Summerize tool use \n as the separator, this will add each gateway as a new line