Delete row below once data is copied above
Hi there,
Can someone help me, I have a problem in that i have a range of data with
part numbers down column A, with various data in columnsB,C,D. The part
numbers could appear one or more times, what i want to do is detailed below.
The range extends to row 1000.
EXCEL: BEFORE
A B C D E
1 ABA 50
2 ABA 20
3 ABA 10
4 ABA 50
EXCEL:AFTER
A B C D E
1 ABA 20 50 10 50
regards Harry
|