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

jlynch's avatar
jlynch
Frequent Visitor
9 years ago

it's not fair to say one answer was correct here, everyone helped me get to the solution, but i marked the solution since that is the direction I went.  Marcel has propelled me to take my limited knowledge of power query to the next level for the next challenge,

 

Thanks to everyone!!!!

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