combining multiple rows into 1

[jtpiazzamn]

I'm importing a JSON file. When I expand the data, its taking a field (Dev_Exp) which allows the user to select mulitple boxes, and Its putting the response into seperate rows (ie: Front end, Back end, UI/UX). The key field is UserID is causing errors as you can't have more than 1 key. Is there a way I can combine the multiple rows, which in this case I need to combine the Dev_Exp column into 1. 

So the result would have Dev_Exp for this user (ID 11) to be "Front end, Back end, UI/UX".

Thank you!

Jim

[AllisonKennedy]

@jtpiazzamn , very similar to this question I just answered: Concatenate unique values from multiple columns - Microsoft Power BI Community

Use the ConcatenateX function if you don't mind this being a measure. Otherwise you could try using Group By functionality, but depends what you want as the end result?

[jtpiazzamn]

@AllisonKennedy  Thank you for your response.  I'd like to combine them and not use a measure. This doesn't affect all users, just some. I'd like to combine the values to show back in the 1 field. As a work around, I did export the API feed to an excel file, which puts all values from the field to 1 cell, and imported that. It sounds like I may have to go back to the dev team and see if there is a way for the data to be saved. . I will try the "group by" function. 

[AllisonKennedy]

@jtpiazzamn How did you get on with the Group By function? 

Also, why do you need it as a column and not a measure? That may help guide what further advice or workarounds we can suggest.