Merge rows which have same values in one column. but not other column.

Question

Hi Guys,

I have table like below. I have to merge only SL_NO column into single row which have same values. like 1  for first four rows, 2  for next four rows. Thanks for your time.