I would like to know if there is any way to group values from a column in a cell
Hi guys
Could you help me with a very specific case?
I would like to know if there is any way to group values from a column in a cell
Example: In my column "A" I have values X, Y and Z.... I would like to group these values in a cell every time I find a related value in another column, as in the formula index + Match, but be able to index all the values in the column when I match specified values. Is this possible?
Best Answers

Hi
I think a JOIN/COLLECT formula might work for it. It will JOIN together into one cell all the data that meets the COLLECT criteria. If you can share a screenshot of your sheets and explain the intended outcome we may be able to provide further guidance.
There is guidance on JOIN and COLLECT here

Hi Victor  Would you like to try this solution to solve your clarification:
Try using the JOIN function to group values from a column into a single cell. Here's how you can do it:
Select the cell where you want the grouped values to appear.
Enter the formula. Type =JOIN(delimiter, range) into the cell, where:
delimiter is the character or string you want to use to separate the values (e.g., comma, space, semicolon).range is the range of cells in the column you want to group. You can select the range manually or use a reference to the column (e.g., A:A for the entire column A).
Press Enter to apply the formula.
For Instance, if you have a column of values in column A (A1:A5) that you want to group with commas as the delimiter, you would enter =JOIN(", ", A1:A5) into the cell where you want the grouped values to appear.
This formula will concatenate all the values in the specified range, separated by the specified delimiter, into a single cell
Thanks
Keep us posted if this helps !!
Huma
Community Leader
Answers

Hi
I think a JOIN/COLLECT formula might work for it. It will JOIN together into one cell all the data that meets the COLLECT criteria. If you can share a screenshot of your sheets and explain the intended outcome we may be able to provide further guidance.
There is guidance on JOIN and COLLECT here

Hi Victor  Would you like to try this solution to solve your clarification:
Try using the JOIN function to group values from a column into a single cell. Here's how you can do it:
Select the cell where you want the grouped values to appear.
Enter the formula. Type =JOIN(delimiter, range) into the cell, where:
delimiter is the character or string you want to use to separate the values (e.g., comma, space, semicolon).range is the range of cells in the column you want to group. You can select the range manually or use a reference to the column (e.g., A:A for the entire column A).
Press Enter to apply the formula.
For Instance, if you have a column of values in column A (A1:A5) that you want to group with commas as the delimiter, you would enter =JOIN(", ", A1:A5) into the cell where you want the grouped values to appear.
This formula will concatenate all the values in the specified range, separated by the specified delimiter, into a single cell
Thanks
Keep us posted if this helps !!
Huma
Community Leader
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.2K Get Help
 321 Global Discussions
 197 Industry Talk
 415 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 277 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!