add ; between numbers

[david gabra]

I have a list of numbers and i want them to be in a row and ; separating between each number - please what is formulae

Employee Number
153554
157944	153554;157944​
157768	153554;157944;57768​
153679	15153554;157944;57768;153679​
157796
153634
152404
154376
154580
158104

 

[rahulshewale1]

hi @david gabra ,

Data Start from Row 1.

C3=TEXTJOIN(",",TRUE,$A$2:A3)

 

[david gabra]

awesome