Basically I have two columns of data, D and E

Because column D has a varying number of spaces between each row and because I ran D through some program that crunched out column E and deleted the spaces I got something like this: (where * = a space)

A A1

B B1

* C1

C D1

* E1

* F1

* *

D *

* *

E *

F *

I want the first column to retain its order and spacing between its rows but I want the second column to match up and align with the first column so that:

A A1

B B1

* *

C C1

* *

* *

* *

D D1

* *

E E1

F F1

How can I do this?

Also second, harder problem:

1) The spreadsheet goes like this~

(Column 1) 1, (Column 2) 1:values, (Column 3) 2, (Column 4) 2:values, (Column 5) 3, (Column 6) 3:values, (Column 7) 4, (Column 8) 4:values,

Is there any code out there that would allow me to select the input (1, 2, 3, or 4) with the highest value for Column 9?

Thirdly (also hard problem)

2) Is there any code out there that would allow me to make a new Column 10 out of Column 9 by transferring the spaces and hyphens in Column 9 into hyphens and turning all the letters lower-cased?

Any suggestions?

At the very least can you help me with the verrrrry first matching formula?

Thank you so much!

Vinson