How I can separate number behind comma in columns at cell array

Hi, I have problem and I dont know how solve it.

Problem is: I have Data in cell format 5x1 cell Data={15; 25; 18,2,3; 35} and I need Data like a matrix which will have numbers separate by comma in diferent columns so first column will [15; 25; 18; 35;] second column [NaN; NaN; 2; NaN] third column [NaN; NaN; 3; NaN] My file have 300 000 rows so I need some function.

Thank you very much for your reponse

Btw: I have matlab version R2012b

Answer 1

[Stephen23]

Download Jos's excellent padcat from FEX:

>> Data = {15;25;[18,2,3];35};
>> padcat(Data{:})
ans =
    15   NaN   NaN
    25   NaN   NaN
    18     2     3
    35   NaN   NaN

[Eduard Sláma]

Thank for answer Anyway my data looks in Command window when I write Data like: '15' '25' '18,2,3' '35' .... And I cant use [] in every single row where is comma I have many dats. But I have idea how get same output which looks like your input.

[Eduard Sláma]

Ok i tried get your input but I get {1x1 cell} {1x1 cell} {1x3 cell} {1x1 cell} and you have [ 15] [ 25] [1x3 double] [ 35]

[Stephen23]

@Eduard Sláma: If you want any help then please edit your question and upload your data by clicking the paperclip button. It would also help if you clearly explained where the data comes from, or how you get into MATLAB memory.

[Eduard Sláma]

I solved this finnaly. But you have true next time I have to more specific my problem, but I am little confused in work with cell so sorry :)) Anyway thx for your response :)

[José-Luis]

The common way of expressing thanks is to Accept an answer once your problem is solved.