Deen,

I feel Pivot Table will do Just the Trick that you want to Pull out...

Create a Pivot Table {Data - Pivot Table} of the Data to be analysed.

Drag in the Columns as first 'Code no.' and then 'amt.'.

The data will fall in just as you had asked for.

Hope that helped.

Sriram

"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