Automatic creation of rows with various permutations of few columnvalues list

N

NT

Hi Folks,

I want to automatically create rows with various permutations of few columnvalues list. For example below is one of the row i have and want to createmultiple rows with various permutations of values allowed for columns Credit_Tier and Reliability_Tier keeping the other columns (Name and Dept) constant.

Name Dept Credit_Tier Reliability_Tier
NT Finance 1a 2a

Example if i have following lists of allowed values for Credit_Tier and Reliability_Tier

Credit_Tier Reliability_Tier
1a 2a
2a 3a

Then excel should automatically create following rows based on four permutation of Credit_Tier and Reliability_Tier allowed values and keeping other columns constant.

Name Dept Credit_Tier Reliability_Tier
NT Finance 1a 2a
NT Finance 1a 3a
NT Finance 2a 2a
NT Finance 2a 3a

If i modify/add values to the Credit_Tier and/or Reliability_Tier list thenthe rows above should automatically change based on new permutations.

Could someone please help in achieving this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatic rows creation with various permutation of column values 2
Excel formula to extract a group of data from another list 2
How to create a list of permutations and combinations? 2
summarize list of expenses 2
Solution to tricky problem of showing exactly Top N rows in Pivottable 0
VLookup Data, Find 2 Adjacent Rows, Return Value in 1 Row 3
Formulas within list fail to update after sorting/filtering 0
Change a Column list into multiple rows & columns 3

Top