Clear Filters
Clear Filters

remove the empty values

5 views (last 30 days)
PA
PA on 14 Jul 2023
Edited: Florian Bidaud on 14 Jul 2023
I want to remove the empty values so that each value has its own variable names
  3 Comments
PA
PA on 14 Jul 2023
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
Dyuman Joshi on 14 Jul 2023
So you want to get the 1st and 3rd row from the excel sheet?

Sign in to comment.

Answers (2)

NAVNEET NAYAN
NAVNEET NAYAN on 14 Jul 2023

Florian Bidaud
Florian Bidaud on 14 Jul 2023
Edited: Florian Bidaud on 14 Jul 2023
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),:)

Categories

Find more on Data Import from MATLAB in Help Center and File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!