Jan 11 2022 02:44 PM
Jan 11 2022 04:45 PM
@JOVANAAI9960409 Hopefully you have Excel 365:
=TRANSPOSE(FILTER($B$2:$B$10,$A$2:$A$10=E2,"none"))
see attached
Jan 11 2022 11:21 PM
@mtarler it doesn't work, because data in one cell of all, is with bigger length. Is there any solution for that to. My example is to match ID with email addresses.
Thank you
Jan 12 2022 05:27 AM
Jan 17 2022 01:41 AM
@mtarler I found a function that solve my problem.
The function is =TEXTJOIN(" ",1,if(A2:A10=E2,B1:B10," ")) .
Sorry for the late response.
Thank you.