how to combine contents from multiple cells into one cell or datevector?

I have just downloaded some data as a .csv and the date came in format: 12,10,1,12,30 (yy,mm,dd,hh,mn) for each column in the row and the data followed in the subsequent columns of each row. I am trying to combine the contents of the five columns into one column or add the columns using datevec so that I can get a datenumber. Anyone know how I would approach this?

Answer 1

[Azzi Abdelmalek]

x={12,10,1,12,30;13,5,24,13,30}
x=cell2mat(x)
x=[x zeros(size(x,1),1)]
y=datenum(x)

[Ryan Dillingham]

perfect! Thanks Azzi, that worked very well. I was then able to turn the datenumber into a datevec which was nice too.

date={[Column1],[Column2],[Column3],[Column4],[Column5]};

date = cell2mat(date);

date = [date zeros(size(date,1),1)];

y = datenum(x);

y = datevec(y);