Aligning rows of data
 

Have table of data

2001 2002 2003
Name # Name # Name #
A 23 A 33 A 29
B 20 B 22 B 29
C 15 D 36 C 12
D 33 E 20 E 48
G 19 F 12 F 19

Each year's data includes a name (A, B, C, etc.) and a number.
However, not all years include all names. How can I match up names in
each row so all "A's" appear in one row, "B's" in one row
etc. along with their corresponding number.

Aligning rows of data
 

maby:

http://pmexcelent.dk/Align.xls

by the way, can u tell me if u se the formula
in english version or DK
if not i can translate later if...