How to stretch (or copy) several cells down automatically in Excel?

Question

excel

There is a table 1.

It is necessary to stretch the columns or copy the cells from the right down to duplicate what is in the first cells.
You should get such a picture, but there are a lot of cells, manually it takes a lot of time.

Two questions:
1. How to copy automatically down.
2. How to stretch the cells down so that the numbers, for example, change to "+1"
In the second case, it will turn out like this:

Answer 1

You need to stretch the columns or copy the cells from the right down to duplicate what is in the first cells.
You should get such a picture, but there are a lot of cells, manually it takes a lot of time.

https://www.google.ru/search?q=excel+fill+down+emp...
With pictures https://www.ablebits.com/office-addins-blog/2014/0...
Option 1 :
- select empty cells with acc. Excel dialog
- enter the formula "=cell above"
- ​​fill the entire range with it
- result: each empty cell refers to the cell above; respectively, those that were empty, as a result, show the values ​​of the cell above them that is filled
Option 2:
Install any of the popular extensions for Excel, such as Ablebits, Kutools, Plex, there are functions that do the same in a couple of clicks
It's more difficult.
Because you do not have numbers, but the text containing them.
You have options:
1. Normalize the table (flies - separately, cutlets - separately): class number, class letter, and store text in separate columns.
2. Write a complex formula that extracts a number from the text, adds it, and puts it back.
Option two is laborious and incorrect. Option 1 is correct.
And most importantly, at least for the given example, the task does not look real - it is difficult to imagine a situation where each next student from the list suddenly studies in a class with a number 1 more than the previous student.

Answer 2

choose how you want to copy and pull as much as you need

Answer 3

Make a shortcut, let's say Ctrl+k . Throw code into macros. Select the desired cell and press Ctrl+k
Macro:

Sub Macro1()
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+k
'
    Selection.Copy
    Range(Selection, Selection.End(xlDown).Offset(-1)).Select
    ActiveSheet.Paste
    Selection.End(xlDown).Select
End Sub