I have the following table and i need to generate the report from the table which includes serial number also
Table:
x 12
y 14
z 20
a 36
y 16
y 54
x 45
Report shall look like the following
Sl.No Name Marks
1 x 12
45
2 y 14
16
54
3 z 20
4 a 36
I am able to hide the duplicate values in name, However, the serial no. column needs to be adjusted as shown above.
pl. help in this regard.