How to link the content of two row in a column

Hi everyone

I would like to know how to link the content of several row (consisting of a constant letter plus a variable number) scattered in a very long column A at the end of the value of the one just below and possibly spaced.

Here an explenation:

image description

Thank you in advance,


ok, simpler solution than I thought…

I solved using the “standard filter” and “insert cells” commands to select values and shift them between adjacent rows and columns.

Thank you again to everyone,