Avoiding blanks while converting a range to a single column

[chullan88]

Hi,

With some help,I have managed to create a formula that converts a range to a single column.
My problem is that,there are some blanks in the range and these values appear as "0" in the single column.
I want the column to show only the values in the range avoiding any blanks.

I have attached the sheet for reference.

Thanks

[AlKey]

Enter this formula in cell L1 and copy down

Please Login or Register  to view this content.

[chullan88]

Enter this formula in cell L1 and copy down

Please Login or Register  to view this content.

Hi Alkey,

Great!!It works..

Would you mind explaining the formulas please??



Thanks