Add values to excel file from an array

I have an array, array1={"A","B","C","D"} whose values need to be entered in excel in the  below format

how can i write to an excel file using excel object?