Formula to Capture Multiple Values for one Identifier

[sherylt13]

Hello All, trying to find an easy way to capture multiple values, in this case training courses, for a detailed list that includes one line per person, where each person may have attended 1+ training courses. The detailed list is then used for a dashboard so the unique list, meaning one line per person, is required.

I have a list of training courses each person has completed, which can be multiple courses and am trying to find the best way to capture the information. I am attaching a picture along with a sample spreadsheet, any suggestions welcome as one solution in my head requires manual intervention for a very long list, so open to any easier solution. Thank you in advance.

Sheryl

Excel Sample.JPG

Attachment 423837SAMPLE List for Multiple Values to One Identifier.xlsx

[samba_ravi]

B2=IFERROR(INDEX('Data Dump'!$B:$B,SMALL(INDEX(('Data Dump'!$A2:$A14<>$A2)*10^10+ROW('Data Dump'!$A$2:$A$14),0),COLUMNS($B2:B2))),"")

Please Login or Register  to view this content.

Try this and copy across
For Dates which date you required 1st Date or last date

[kvsrinivasamurthy]

For courses Array formula
In B2, then drag Across upto E column.

Please Login or Register  to view this content.

for Last Date Array formula

Please Login or Register  to view this content.

[sherylt13]

Thank You both for the (uber) quick responses, very helpful !

[Czeslaw]

Another option.

[sherylt13]

Another new formula for me to learn, thank you !