Best way to pull every other row from excel?

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!

Answer 1

[Cris LaPierre]

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)

[chlor thanks]

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!