title: Try to make a column of named school classes: 1A, 1B, 1C, 1D, 2A, 2B in one column using just one-cell formula
body: <p>I challenged myself and make a formula that produces a column of class names.
  My goal was to make it in one cell and without repeating the same commands.
  I failed.
  My best result is a column of commands that makes an array and then this array is flattened.
  I believe it can be done. I tried more nested arrayformulas but with no good result.
  Do anyone have a time to try this exercise?
  I think using a script is unsporty here. ;-)</p>
  <p>Array is made using this formula for each row (19 to 26):</p>
  <pre><code>=ArrayFormula(sequence(1;B5;A5;0)&amp;CHAR(sequence(1;B5;65;1)))
  </code></pre>
  <p>Then I flatten it and remove empty cells:</p>
  <pre><code>=query(flatten(A19:I26);&quot;select * where Col1 is not null&quot;)
  </code></pre>
  <p><a href="https://i.stack.imgur.com/idySO.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/idySO.png" alt="enter image description here" /></a></p>
  <p>Here is my playground:
  <a href="https://docs.google.com/spreadsheets/d/1udZ1NAkv1EmIAXlCZz_CMCK6wkG2U-JSklM3fc7UJP8/edit#gid=0" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1udZ1NAkv1EmIAXlCZz_CMCK6wkG2U-JSklM3fc7UJP8/edit#gid=0</a></p>