Array formula: Automatically create a series of values for a one-dimensional matrix

Of course, columns are named by letters and not numbers, stupid of me

Thank you, both suggestions works like a charm! And the transpose version makes it a little more simple to count manually