Merging 2 columns into 1 alternating every other column with ability to omit empty cells

[anilsen0711]

I found the following link very helpful and was able to accomplish half of what i need to do.

http://www.excelforum.com/excel-gene...er-column.html

Here is my data: (The " " denotes an empty cell)

1 2
3 4
5 " "
6 7

Desired Result:

1
2
3
4
5
6
7

Current Result: I am currently copying down the following formula =INDEX($A:$B,CEILING(ROWS(C$1:C1)/2,1),2-MOD(ROWS(C$1:C1),2))
The empty cell shows as a 0. I would like to just skip the blank cell and continue on.

1
2
3
4
5
0
6
7

[mehmetcik]

I think a user defined function is easier.

wait a few mins

[mehmetcik]

Ok

Here is your function. Sample spreadsheet attached.

The function accepts three variables the last being optional.

First = range to modify
Second is the position in the output to display
Third is the Show blanks flag, default = 1 so shows Blanks.

Please Login or Register  to view this content.

[anilsen0711]

mehmetcik thanks for you response. This works well exactly what I was looking for.