Is it possible to have a sole input row where the data automatically transfers down to rows 3-1000 in alphabetical order?

The transfer must take all column data in sole input row 2 and transfer it into rows 3-1000.

Does anyone have any suggestions? Can it be done?


Thanks for any help.