Different Cells data into One for a specie ID based cells

[aaajithk]

[#2]

@aaajithk 

See the attached sample workbook.

[#3 · Accepted solution]

thank you soo much for your effort.

[#4]

it is really helpfull

[#5]

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,""))) 

433890	44420
433899	44245, 44244

@Hans Vogelaar 

[#6]

@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?

[#7]

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!!

[#8]

@bfield66 

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