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