Upload text file and rearrange columns

Hi,

I am trying to input the file attached titled "input_file.txt" into MATLAB and organise the content so as to output in the format as seen in "desired_output.xlsx".

Answer 1

[Monisha Nalluru]

For loading the txt file into MATLAB, you can use importdata.

In order to process data into desired output, you can use split function which will be helpful to discard the sentence at required delimiter.

For writing the data to excel you can use writecell, writetable, writematrix depending on the way data is stored.