hi everyone, l am new in vba and need a favour.

l have data type like this:

1 a j
1 b k
1 c l
2 d m
2 e n
2 f o

in this sheet, the numbers in the first column are unique. the following columns may be one or more and are not unique. for example, the first column contains the student numbers and the following ones contain the lectures.

l need a macro to merge cells according to these rules:

1- the repeating values of the first column are merged in one cell as a single value like 1, 2, or 3...

2- then, the following columns' values are merged not losing any data within the range of the first columns unique values.

the result must be like this:

a j
1 b k
c l

d m
2 e n
f o

abc, jkl, def and mno must be in the same cell and written over and over. l hope l have explained well.

thanx...