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?
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
The Summarize tool can do this, as below (choose 'group by' on the sales field and then 'concatenate' on the email field):
Hello,
this is easily achievable using the corss tab tool with this configuration:
Hi guys, thanks for sharing.
No worries @zqlcancer! glad it worked for you
