Combine Lists

[Michael Dobony]

I have a list1 in f41:f56 and a list2 in g41:g56. Both are formulas pulling
from another list. I want to combine these to one list with either a single
blank cell between them or no blanks. I tried the following formula, but
it gives me a long group of blanks between the two lists. I need to do this
with a formula, not VBA.

=IFERROR(INDEX(List1, ROWS(C1:$C$1)), IFERROR(INDEX(List2,
ROWS(C1:$C$1)-ROWS(List1)), ""))

Also, when I copy things get crazy. The second row of the new list copies
this way:

=IFERROR(INDEX(List1, ROWS(C$1:$C2)), IFERROR(INDEX(List2,
ROWS(C$1:$C2)-ROWS(List1)), ""))

Any idea what's happening here? I had to copy the text and modify the
formula by hand to the correct progression.

 

[isabelle]

hi Michael,

assume that List 1 and List 2 are:
a1 b1
a2 b2
a3 b3
etc ...

what do you want to get as a result?

isabelle

Le 2013-03-07 18:12, Michael Dobony a écrit :