Organizing Information in excel line to column (need this for work)

Hi,

For example I have two lines like this:

AAAAAAAAAAAAB
AAAB

Now I want to construct a single column with all the A's from both lines (the copy of the line must stop when I find B):

How do I do this? I can for instance give a name to each line, like link1 and link2 if you find helpful. I also have to work with several links (it may be 20 lines), so if possible avoid array formulas.

Thank you in advance,

And happy new year

No need to double post - I have replied to your other one.

Pete