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!!

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

<tbody>
</tbody>

 

[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