Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

New column when IDs repeat

Hello community,    I'm looking to create a new column with a list of unique medications for each ID.    I have a bit of a weird/complicated data, because my IDs repeat:  ID Medication 1 ...
Need Help
Fowmy's avatar
Fowmy
Super User
5 years ago

Anonymous 

Based on your question and the sample you provided, solutions were suggested. You can share your Excel file or create a sample file that represents your actual data and show the expected results to understand your data and the expected result.

You can save your file in a cloud space like OneDrive and share the link here.


Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hello Fowmy , 

 

Thank you, I have tried to upload it here, does it work? 

 

Thank you for your help, I really appreciate it. 

 

Kind regards, 

 

Denisse