New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

All Possible Column Combinations

Macros, VBA, Excel Automation, etc.

All Possible Column Combinations

Postby vikas+jain » Tue Apr 19, 2016 4:08 am

Hi All-

I have to generate data from a sample Data wherein I need to combine all the columns with all the permutations and combinations.

For Example:

Column A ColumnB ColumnC ColumnD ColumnE ColumnF ....................................
Day c009 UNIX Abend xxFile Followup will be required with XXPONPC team
Night a009 JAVA Error xxCopy Followup will be required with Database team
b009 .Net


The End Product should be like:

Column Z
ColumnA: Day, ColumnB: a009, ColumnC: JAVA,.................................ColumnF: Followup will be required with Database team


ColumnA: Night, ColumnB: c009, ColumnC: UNIX,.................................ColumnF: Followup will be required with XXPONPC team

Thanks in anticipation.

Regards,
Vikas
  • 0

vikas+jain
Rookie
 
Posts: 1
Joined: Apr 19, 2016
Reputation: 0
Excel Version: 2010

Re: All Possible Column Combinations

Postby pecoflyer » Tue Apr 19, 2016 6:38 am

Hi

please post a sample sheet showing your data and expected results

Thank you
  • 0

A relevant topic title helps get faster and more answers
pecoflyer
Moderator
 
Posts: 1274
Joined: Jan 24, 2012
Location: Belgium
Reputation: 39
Excel Version: 2003/2007/2010


Return to Macros and VBA Questions

Who is online

Users browsing this forum: No registered users and 28 guests