You can enter this equation into A5, and fill across. Let me know if it works:

=OFFSET(A1,0,COLUMN()-1)