How can I split up several data (string, number) in one cell from an excel file?

Hello community,

I am new to matlab and I imported an excel file which includes data of string, number and dates (all data are in the same column) and I want to split it into 3 columns.

Information of the data:

example:

Person XYZ
12345678
01.01.1990
Person ABC
19876543
01.11.1995

and I want to "transpose" the data like that:

column 1        column 2       column 3
Person XY     12345678    01.01.1990
Person ABC   19876543    01.11.1995

I think its not that difficult to solve this problem, I already tried so solve it with a for loop and if statement but I have some problems to get the right syntax.

Thanks in advance!

stay safe!!! :-)

[Bob Thompson]

If you use cells to store you data, then you should be able to use reshape to reorganize the data.

[dpb]

And, in fact, given the mixed content in the file, you'll get a column of cellstr() when you read the Excel file automagically so really have almost nothing left to do! :)

Answer 1

[Arjun]

Hi @Victor Szenes,

Here is an existing MATLAB answer which might be helpful to you, as it addresses the same issue that you are facing.

https://www.mathworks.com/matlabcentral/answers/782483-array-with-name-number-date-in-the-same-column-and-i-need-help-to-split-them?s_tid=srchtitle

Hope this helps!