How to change letters when dragging a table to the right?

Question

excel

Good evening, in the table you need to convert the values ​​​​from column A to a similar table . I can’t figure out how to do this. Thanks for the help!

Answer 1

Formula:
Insert into the desired cell, drag down and to the right