Transpose Question

[mzsweetumz]

Hello,

I am comparing full names within multiple datasets and would like to have each dataset as one column, and highlight the row numbers where the full names appeared in separated by commas:

Example: The name 'Taylor Swift' appears in Report 2 in rows 5, 7, 8

Thank you!!

[Luke_C]

Do you have an example of the raw data?