Need To Combine Many Rows and Columns

[MRRinWalburg]

I have six columns with anywhere from 5 rows to 99 rows in each column. I need to combine EVERY possible combination of the rows. Here's some of the data. I know how to concatenate, but don't think that is what I need to do. Please help!!


[TABLE="width: 526"]
<tbody>[TR]
[TD]Entity[/TD]
[TD]Location[/TD]
[TD]Department[/TD]
[TD]GL Account[/TD]
[TD]Fund[/TD]
[TD]Project[/TD]
[/TR]
[TR]
[TD]E100[/TD]
[TD]L100[/TD]
[TD]101[/TD]
[TD]50000[/TD]
[TD]UNR[/TD]
[TD]P1000[/TD]
[/TR]
[TR]
[TD]E200[/TD]
[TD]L101[/TD]
[TD]102[/TD]
[TD]50105[/TD]
[TD]1000[/TD]
[TD]P1005[/TD]
[/TR]
[TR]
[TD]E300[/TD]
[TD]L102[/TD]
[TD]110[/TD]
[TD]50110[/TD]
[TD]1005[/TD]
[TD]P1010[/TD]
[/TR]
[TR]
[TD]E400[/TD]
[TD]L103[/TD]
[TD]120[/TD]
[TD]50115[/TD]
[TD]1010[/TD]
[TD]P1015[/TD]
[/TR]
[TR]
[TD]E500[/TD]
[TD]L104[/TD]
[TD]200[/TD]
[TD]50120[/TD]
[TD]1015[/TD]
[TD]P1020[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]L105[/TD]
[TD]210[/TD]
[TD]50125[/TD]
[TD]1020[/TD]
[TD]P1030[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]L400[/TD]
[TD]251[/TD]
[TD]50130[/TD]
[TD]1040[/TD]
[TD]P1100[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]L500[/TD]
[TD]252[/TD]
[TD]50305[/TD]
[TD]1041[/TD]
[TD]P1105[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]260[/TD]
[TD]50310[/TD]
[TD]1042[/TD]
[TD]P1150[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]300[/TD]
[TD]50315[/TD]
[TD]1043[/TD]
[TD]P1155[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]310[/TD]
[TD]50400[/TD]
[TD]1044[/TD]
[TD]P1160[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]330[/TD]
[TD]50600[/TD]
[TD]1070[/TD]
[TD]P1205[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]341[/TD]
[TD]50700[/TD]
[TD]1105[/TD]
[TD]P1210[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]342[/TD]
[TD]50800[/TD]
[TD]1110[/TD]
[TD]P1215[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]343[/TD]
[TD]50905[/TD]
[TD]1115[/TD]
[TD]P1220[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]351[/TD]
[TD]50910[/TD]
[TD]1120[/TD]
[TD]P1225[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]352[/TD]
[TD]50915[/TD]
[TD]1125[/TD]
[TD]P1230[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]353[/TD]
[TD]50920[/TD]
[TD]1130[/TD]
[TD]P1235[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]400[/TD]
[TD]50925[/TD]
[TD][/TD]
[TD]P1240[/TD]
[/TR]
</tbody>[/TABLE]

 

[jmacleary]

Hi there. Have you thought this through? Even with your partial table, there are nearly 5 million combinations!! (5*8*19*19*18*19).

 

[sandy666]

you can try Cartesian in Power Query but as mentioned above this is 4938480 combination and you will not be able to load it into the sheet.
Limits: Total number of rows and columns on a worksheet 1,048,576 rows by 16,384 columns