Merge active cells

[jyothijayanna]

Hello,

I am looking for a formula to merge columns "A" through "I" to the left, while ignoring blank cells. Yellow columns are the desired result - thanks

[shg]

In L2, confirmed with Ctrl+Shift+Enter:

=IFERROR(INDEX($A2:$I2, SMALL(IF($A2:$I2<>"", COLUMN($A2:$I2) - COLUMN($A2)+1), COLUMNS($L1:L1))), "")

Copy across and down.

[jyothijayanna]

Thanks Tex.....it worked perfectly.