remove the empty values

I want to remove the empty values so that each value has its own variable names

[Florian Bidaud]

Hi,

Remove the empty values from what ?

What do you mean by 'each value has it own variable names' ?

Can you share your code ?

[PA]

This is the excel file and the output i need is L and T but i get this output as shown in the image

[Dyuman Joshi]

So you want to get the 1st and 3rd row from the excel sheet?

Answer 1

[NAVNEET NAYAN]

Please take hint/help from the following link:

https://in.mathworks.com/matlabcentral/answers/27042-how-to-remove-empty-cell-array-contents

Answer 2

[Florian Bidaud]

A = readtable("Book2.xlsx")
L1 = A.Value1([A.Parameters{:}] == 'L')
L2 = A.Value2([A.Parameters{:}] == 'L')
T1 = A.Value1([A.Parameters{:}] == 'T')
T2 = A.Value2([A.Parameters{:}] == 'T')

If you want to keep a table :

B = A(~isnan(A.Value1),:)