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
Bookmarks