need Excel Macro with array function

i need to arrange 4 columns and 28 rows data into multiple sheets with cross combinations

 

like 

C1 C2 C3 C4

R1 a a a a

R2 b b b b

R3 c c c c

R4 d d d d

resulting

 

C1 C2 C3 C4

R1 aaaa aaab aaac aaad

R2 abaa abba acca adda

so on upto 28 rows and 28 columns

 

any suggestions

 

By: N

Leave a Reply

Your email address will not be published. Required fields are marked *