sort data base on one column to multiple columns

example
from this

A B C D ...
aaa aaa tyr sfd
sfd sfd kre ewr
ewr ewr aaa tyr
tyr tyr sfd aaa
kre

to this

A B C D
aaa aaa aaa aaa
sfd sfd sfd sfd
ewr ewr <Blank> ewr
tyr tyr tyr tyr
kre <Blank> kre <Blank>

Can this be done by sorting? or does it require a macro? I have column B all the way to Z with similar data, but all mixed right now. Column A has all the names that column b to z would have. any way to do this?



Thanks for your help.

Thanks for your help btw.

Yes i have headers for the first 2 rows. The data starts at row 3. I can use macros, but just don't know how.

thanks.

Ignore my earlier post regarding Column A having all the data because sometimes we have new names and it doesn't have everything.

If you guys can make me a macro that sorts Column A to Z, like my example would be great. Put blanks where the name isn't there.

thanks.

Just wanted to give this a bump, and help would be appreciated.

thanks.