Problems with consolidation
 

Hi all,

Managed to solved the connection problems already. However, i got stuck with
one more issue.

I realised that when i use the filter function to remove the blanks. I sieve
down to the remainder. When i try to copy those information over. It seems
that if it's a single row, it would disappear and the formula would apply.

However if there is more than 1 row involved, then it becomes data which i
can pull easily.

Any idea how i can resolve this?