I have data in excel sheet with two columns and I want to create a third column in place of the first one.

Hi all, I have data in excel sheet with two quantities Force [1st column] and Angle[2nd column]. I want to create a Time stamp using for loop in first column moving force to 2nd column and angle to 3rd, without changing their values.

[dpb]

HINT: No for loop needed to do this; use colon operator or linspace. datetime may be of interest.

Answer 1

[Kathleen T. Nevola]

You could use the for loop to make a vector of time stamp values and then concatenate the timestamp vector with the force and angle matrix to get a new matrix to export to excel.

mat = [Force Angle]

new_mat = [Time_stamp mat]

Assuming the vectors have the same length.

For more on writing data to excel check out this link: https://www.mathworks.com/help/matlab/import_export/exporting-to-excel-spreadsheets.html