Sleeper: Macro to stack lists until empty

[wiro]

Hi

I have two lists that are generated from user input. They vary in length and can be a maximum of 1000 rows each.

1. The first list adds a + in front of every word.
2. The second list adds brackets [] around each phrase.

I'd like to use a macro to stack the lists until they're empty.

Column B has the first list. There are SUBSTITUTE formulas in every cell down to row 1001. Same goes for column D, which holds the second list.

Assume that I put in values and generate two lists of 20 rows each. I want the macro (activated by a button) to stack the both lists and create a 40 row list.

I've tried a couple of online solutions but to no avail.

EDIT: Uploaded a file for reference.

[SamT]

Use Go Advanced and below the post Editor, the Manage Attachments to upload a sample workbook with a "Result" sheet showing what the final result of the macro should look like.

Include about 10 items in all lists and about 10 formulas in that column on the "original" sheet