transform

[Anonymous]

no		required output
1		1
1		1
2		2
3		3
3		3

I have a column no (as shown above) ,i want it to transform into the required output.

Regards,

Ganesh.

[Anonymous]

no	A	B	=rowno(total)
1	x	a	1
1	x	b	2
2	x	c	3
3	y	d	4
3	y	r	5
4	t	t	6
5	t	t	7

the output should be as follows :

1

1

2

3

3

4

5

[renjithpl]

Hi

if i understood your question.

in the output filed, just give =no.

Regards

Ren