I would like to use EXCEL VBA ARRAY way, let the blank cell on the left side of the table to fill in the top of the value, and change into the right form, if someone can help, I will be very grateful.
Select the range of all those cells, I'm assuming your data is in A1:D5
then Press F5, Special, Blanks
Type: =B$1 or whatver the reference to the Top Row is above the blank cell that is selected, Then Press Ctrl+Enter
