Copy data from Sheet 1 and Paste into Sheet 2

Create a helper column C
In C2: =COUNTIF($A$2:A2,A2)=1
Drag the Fill Handle down as far as needed
AutoFilter the False and Delete them, when you done Delete helper column




"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