...
Using the tiny square known as the 'fill handle' in the corner of the selected cell, you can drag it (drag-down) to repeat the values from the cell. Double-click the fill handle in cell B4
where the value is 30
to fill the selection down to the last value in neighboring column, just like it would in Excel or Google Sheets.