On Apr 6, 1:32 pm, Mike wrote:
Why don't you just filter on F0001 etc

Mike

"deen" wrote:
Eg:

In Sheet1 i have data like

Code No Amt

F0001 100
F0001 10
F0001 20
F0002 50
F0002 60
F0002 70
F0002 200

I Need result in sheet2 like,

Code No Amt
F0001 100
10
20

F0002 50
60
70
200

Pls Help Me,

Regards
Deen

It will going to happen in diffrent excel,

the value contain in rows ways, i want to get the all the values in
sheet2