I need a worksheet formula that can do this :
data in columns: result:
A B U V W X Y Z
1 bill 22 1 bill 22 7 4 7 22
2 bill 7 2 joe 5 5
3 bill 4 3 ian 8 10 8 6
4 bill 7 4 ann 3 8 10
5 bill 22
6 joe 5
7 joe 5
8 ian 8
9 ian 10
10 ian 8
11 ian 6
12 ann 3
13 ann 8
14 ann 10
and so on down to 1002 rows for column A
Thanks every one
bill gras