Forum Discussion

jlynch's avatar
jlynch
Frequent Visitor
9 years ago
Solved

calculated column to display comma separated values as the text lookup value for each value

I have two tables, one lists the text string values and an ID, the other has a comma separated list of ID's, i want to display a concatenated text list in a single cell based on the ID's in the main ...
Tutorial Requests
  • Greg_Deckler's avatar
    Greg_Deckler
    9 years ago

    I believe what you want is a VALUES and CONCATENATEX formula

chandrasekhar1's avatar
chandrasekhar1
New Member
8 years ago

What if the Source data is like below:

 

ID     Value

__      ________

1             X

1             Y

2             Z

2             A

2             B

3           

4             C

5             D

6             E

6             F

 

and My output should be 

 

ID          Value

-----       ---------

1               X,Y

2               Z,A,B

3

4              C

5              D

6              E,F

 

 

Please let me know.

 

Thanks

Chandra

Anonymous's avatar
Anonymous
Not applicable
8 years ago

hi chandrasekhar1,

 

     Did you get any way out or resolution for your posted issue. I too want to create a id column that has comma separated value just like you asked. Let me know if you have resolved it.

 

Regards,

Hemant