Array with name, number, date in the same column and I need help to split them

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:

string=name

number=ID

date=birthdate

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!!! :-)