what are steps to create a combination array ?

what are steps to create a combination array which are given through imported excel sheet then exporting the results to anther excel sheet ? note:the elements of the table are numbers

[mohammad]

please to answer the question necessary

Answer 1

[Ilham Hardy]

doc xlsread
doc xlswrite

to combine array

C = [A B]; or C = [A,B];

[mohammad]

Thank you for your answer, but this is not what I want . please visit this site and you will find what i need exactly but through the matlab functions and not through Excel function http://stackoverflow.com/questions/10692653/excel-vba-to-create-every-possible-combination-of-a-range?answertab=oldest#tab-top

Answer 2

[Andrei Bobrov]

[~,~,c] = xlsread('E:\xlsfile1.xlsx');
c1 = c(3:end,:);
ii = cellfun(@(x)all(~isnan(x)),c1);
n = sum(ii);
idx = bsxfun(@plus,fliplr(fullfact(n)),[0 cumsum(n(1:end-1))]);
c2 = c1(ii);
out = c2(idx);
xlswrite('E:\newxlsfile.xlsx',out);