sorting(?) problem

  • Thread starter Thread starter Colargol
  • Start date Start date
C

Colargol

Hi!

I have problems generating a rutine that will automatically sort my
sheet.
The sheet is in this format (always 2 columns only the rows may vary)

a 1
a 2
a 3
b 2
b 1
c 7
d 1
d 3
d 4
d 6
d 7
e 7


I want it to look like this:

a b c d e
1 2 7 1 7
2 1 3
3 4
6
7

Anyone know what vba code to use to get this done?

/Colargol
 
Back
Top