However, by embedding the SEQUENCE function within the TRANSPOSE function, you can force Excel to fill the numbers down the rows, and then across the columns.