text/number in different column

[sudipto3003]

dear friends,

I have a sheet attach here where I have a data, where name & numbers are in a single column, but I need them separately column wise. I have attached the sheet herewith for your reference. Please suggest the way out to do it.

thanks In advance
sudipta

 

[Asheesh]

@sudipto3003 -

Does this help...

 

[Asheesh]

one more...this is a non array solution

INDEX($A$2:$A$13,COLUMNS($A$1:A$1)+(ROWS($A$1:$A1)-1)*$J$1,1)

$J$1 referes to the block of rows as explained in the previous attachment..

 

[echo99]

@sudipto3003

i hope this can help

Regards,
echo99