SOLVED

Different Cells data into One for a specie ID based cells

New Contributor
7 Replies

@aaajithk 

See the attached sample workbook.

best response confirmed by aaajithk (New Contributor)
Solution
thank you soo much for your effort.
it is really helpfull

I'm able to use the formula you provided, but need to convert the numbers back to dates.  For example, the 6 digit number in the first column is correct, but the 5 digit number in the second column needs to be in mm/dd/yyyy format. Here's your formula for reference. Thank you!

 =IF($B116=$B115,"",TEXTJOIN(", ",TRUE,IF($B:$B=$B116,C:C,""))) 
43389044420
43389944245, 44244

@Hans Vogelaar 

@bfield66 

Use something like the following, adjusting the ranges:

=IF($A2=$A1,"",TEXTJOIN(", ",TRUE,IF($A$2:$A$11=$A2,TEXT(C$2:C$11,"mm/dd/yyyy"),"")))

By the way, why did you mark your own reply as the best response?

I think that was the person you initially helped. I found this string and seen that it fit what I was looking for. Your response is best!!

@bfield66 

My apologies, I see now that you're not the original poster.