How to select and write values from data into excel

I have a single column of 98820 values i want to divide them into groups of 4941 and write them in separate columns in excel

Answer 1

[Jan]

x = rand(98820, 1);
y = reshape(x, 4941, 20);
xlswrite(FileName, y);

[John BG]

what if 98829/4941 is not integer? then this doesn't work.

[Image Analyst]

Correct (though this more general question wasn't asked). If the vector is not an integer multiple of the number in a group, then Arslan should choose a different group size or else re-think what he wants to do. For the stated numbers, this works.

[Arslan F]

98820/4941 is an integer its 20 (its not 98829)