Automatic rows creation with various permutation of column values

N

NT

Hi Folks,

How can i automatically create rows in excel with various permutations of few column values. For e.g.

Name Dept Credit Tier Reliability Tier
NT Finance 1a 2a
 
D

Don Guillett

Hi Folks,

How can i automatically create rows in excel with various permutations of few column values. For e.g.

Name Dept Credit Tier Reliability Tier
NT Finance 1a 2a

You get more of an answer with more explanation of
 
Top