Data consolidation

[miki2024]

Hi mighty community,

I'm trying to merge two data sets into one.

Dataset 1 contains list of student information such as name

student ID  name

112233       David

113344       Peter

Dataset 2 contains the grades of the student per subject enrolled

student ID   Grade

112233         A

112233         B

112233         D

113344         B

113344         C

What is the best way to combine the dataset and display the information as below (regardless of subjects, just showing the list of grades)?

student ID   name       Grade

112233         David     A, B, D

113344         Peter     B, C

cheers!

[gawa · Accepted solution]

@miki2024 

Multiple ways to do so but anyway basic Join+Summarize will suffice. 

[caltang · Accepted solution]

Like so:

[caltang · Accepted solution]

If it helps @miki2024 , can you kindly mark both @gawa and I's solutions as accepted solutions to close the thread as is? It'll help others find the solutions faster as well.

Thanks!

[miki2024]

Instead of JOIN, how about Find/Replace (Append function)?

[gawa]

@miki2024 

IN your case, Find/Replace will also work because of single key field.