Combining a Datetime matrix (8760 x 1) with another cell matrix (8760 x 2)

Hello, I have a data set of (8760 x 3)wherein a extracted just the first col of the data( in this format 'uuuu-MM-dd''T''HH:mm:ssXXX') to convert it to another format ('yyyy-MM-dd hh:mm:ss'). Thus I obtained a datetime matrix of (8760 x 1).

1. How do i replace this new format of datetime with the longer format (row 1 ) of my original file of cell matrix.

I get an error regarding the type of matrices, and that they cant be combined.

[Peter Perkins]

Tushar, I think you're going to need to give a specific, short example of what you're tyring to do.

Answer 1

[Steven Lord]

If you want your data stored in tabular form, and you're using release R2016b or later, consider storing your data in a timetable.

[Tushar Agarwal]

Thank you for taking out the time.

I am fairly new with this. What I mean to ask, is that how do I combine two matrices of different types.

One is a double matrix, and the other a datetime.

I am not able to combine the two with double(:,3)=datetime(:,1);

The error is All inputs must be datetimes or date/time strings.

I want to replace the 1st col of Data with col T.