MATLAB Answers

Best way to pull every other row from excel?

3 views (last 30 days)
I have a row of data in excel that goes something like this:
Anna
34
Brandon
55
Calvin
89
What is the best way to pull these information out into a text file as something like this?
Anna Brandon Calvin
34 55 89
Thank you very much!

Accepted Answer

Cris LaPierre
Cris LaPierre on 12 Mar 2020
The challenge here is you are mixing data types. I would recommend using a table with names in one variable and corresponding number in a second variable. Something like this could work.
data = readtable("ChlorThanks.xlsx","ReadVariableNames",false)
name = string(data.Var1(1:2:end));
val = str2double(data.Var1(2:2:end));
newData = table(name,val)
  1 Comment
chlor thanks
chlor thanks on 12 Mar 2020
Thank you! It has been a while since I used matlab and this is a great refresher for me to remember things again, really appreciate your help!

Sign in to comment.

More Answers (0)

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by