How to save to different column array

Hi, I have below matrix and I want to save each column into different arrays (or single column matrix) if at least one row exists a numeric value(because 3rd column does not contain any numeric values, all "NA"):

Input matrix:

1  3   NA  5 
2  NA  NA  NA
5  NA  NA  NA
6  NA  NA  8

My output should be:

Y1:
1   
2  
5 
6 
Y2:
  3    
  NA  
  NA  
  NA 

Y3:
  5 
  NA
  NA
  8

Please someone help me how to do this,many thanks in advance:

Answer 1

[Adam]

Y = [1 3 NaN 5; 2 NaN NaN NaN; 5 NaN NaN NaN; 6 NaN NaN 8]
Y( :, sum( isnan( Y ) ) == size( Y, 1 ) ) = [];

will remove the columns you don't want, in-place. You can obviously take a copy of your matrix if you still want the original.

There is no reason why you should split it into individually named variables though.

Y(:,1), Y(:,2) works far better than Y1, Y2 in further code.

Answer 2

[Thorsten]

 Y(:, all(isnan(Y))) = [];

Answer 3

[Stephen23]

>> M = [...
    1,  3,NaN,  5
    2,NaN,NaN,NaN
    5,NaN,NaN,NaN
    6,NaN,NaN,  8];
>> out = M(:,any(isfinite(M),1))
out =
     1     3     5
     2   NaN   NaN
     5   NaN   NaN
     6   NaN     8
>> out(:,1)
ans =
     1
     2
     5
     6