SOLVED
How to combine data in one cell?
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
zqlcancer
8 - Asteroid
‎05-19-2022
02:03 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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?
Solved! Go to Solution.
Labels:
- Labels:
- Custom Tools
5 REPLIES 5
17 - Castor
‎05-19-2022
02:06 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
6 - Meteoroid
‎05-19-2022
02:15 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
AlexEntz
8 - Asteroid
‎05-19-2022
02:17 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello,
this is easily achievable using the corss tab tool with this configuration:
‎05-19-2022
02:40 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi guys, thanks for sharing.
17 - Castor
‎05-19-2022
02:43 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
No worries @zqlcancer! glad it worked for you
