How to combine data in one cell?

[zqlcancer]

Is there any tool available to help user combine data in different cells in one cell based on specific data? e.g. in my example, I would like to combine the different ‘Customer Email’ for each sales?

[IraWatt · Accepted solution]

Hey @zqlcancer,

A summarize can achieve that:

You can group by your sales category and concatenate the emails for each category with a ";" separator.

HTH,

Ira

[gambiera · Accepted solution]

The Summarize tool can do this, as below (choose 'group by' on the sales field and then 'concatenate' on the email field):

[AlexEntz]

Hello,

this is easily achievable using the corss tab tool with this configuration:

[zqlcancer]

Hi guys, thanks for sharing.

[IraWatt]

No worries @zqlcancer! glad it worked for you