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
 63.8K Get Help
 406 Global Discussions
 218 Industry Talk
 457 Announcements
 4.7K Ideas & Feature Requests
 141 Brandfolder
 136 Just for fun
 57 Community Job Board
 459 Show & Tell
 31 Member Spotlight
 1 SmartStories
 297 Events
 37 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!