Spreadsheet: 822546d1679412219-array-like-formula-to-create-combinations-book3
Sheet: Sheet1

ES
Entity Code |  |  |  | Division Codes |  |  |  | Dep. Codes |  |  |  |  |  |  |  |  |  |  |  |  |  | Program Codes |  |  |  |  |  |  |  |  |  |  |  | SubProgram Codes |  |  |  |  |  | Account Codes |  |  |  |  |  |  |  |  |  |  |  | Grant Codes |  |  |  |  |  | Event Codes |  |  |  |  |  | Semester Codes |  |  |  |  |  | Employee Codes
2022 |  | 2023 |  | 2022 |  | 2023 |  | 2022 |  |  |  |  |  |  | 2023 |  |  |  |  |  |  | 2022 |  |  |  |  |  | 2023 |  |  |  |  |  | 2022 |  |  | 2023 |  |  | 2022 |  |  |  |  |  | 2023 |  |  |  |  |  | 2022 |  |  | 2023 |  |  | 2022 |  |  | 2023 |  |  | 2022 |  |  | 2023 |  |  | 2022 |  |  | 2023
 |  |  |  |  |  |  |  | 121 | 120 |  |  |  |  |  | 121 | 120 |  |  |  |  |  | 1000 |  |  |  |  |  | 1000 |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  | 121 |  |  |  |  |  |  | 121 |  |  |  |  |  |  | 1206 |  |  |  |  |  | 1206 |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  | 121 |  |  |  |  |  |  | 121 |  |  |  |  |  |  | 1211 |  |  |  |  |  | 1211 |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  | 121 |  |  |  |  |  |  | 121 |  |  |  |  |  |  | 1204 |  |  |  |  |  | 1204 |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  | 121 |  |  |  |  |  |  | 121 |  |  |  |  |  |  | 1203 |  |  |  |  |  | 1203 |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  | 121 |  |  |  |  |  |  | 121 |  |  |  |  |  |  | 1202 |  |  |  |  |  | 1202 |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  | 121 |  |  |  |  |  |  | 121 |  |  |  |  |  |  | 1201 |  |  |  |  |  | 1201 |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  | 122 | 322 |  |  |  |  |  | 122 | 322 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  | 121 | 127 |  |  |  |  |  | 127 |  |  |  |  |  |  | 1209 |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  | 128 |  |  |  |  |  |  | 128 |  |  |  |  |  |  | 1212 |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  | 121 |  |  |  |  |  |  | 125 |  |  |  |  |  |  | 1214 |  |  |  |  |  | 1214 |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  | 120 | 121 | 122 | 125 | 127 | 128 | 322 | 120 | 121 | 122 | 125 | 127 | 128 | 322 |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  |  |  |  |  |  |  |  |  |  |  |  |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank |  | BLank | Blank
=LET(a,IF(COUNTA(A6:B6)=0,"@",A6:B6),
b,IF(COUNTA(e6:f6)=0,"@",e6:f6),
c,IF(COUNTA(I6:O6)=0,"@",i6:o6),
d,IF(COUNTA(W6:AB6)=0,"@",W6:AB6),
e,IF(COUNTA(AI6:AK6)=0,"@",AI6:AK6),
f,IF(COUNTA(AO6:AT6)=0,"@",AO6:AT6,
ac,COUNTA(a),
bc,COUNTA(b),
cc,COUNTA(c),
dc,COUNTA(d),
ec,COUNTA(e),
fc,COUNTA(f),
aCol,TEXTSPLIT(TEXTJOIN(" ",,REPT(a&" ",bc*cc*dc*ec*fc)),," "1),
bCol,TEXTSPLIT(    REPT(TEXTJOIN(" ",,REPT(b&" ",cc*dc*ec*fc)),ac    ),," ",1),
cCol,TEXTSPLIT(    REPT(TEXTJOIN(" ",,REPT(c&" ",dc*ec*fc)),ac*bc ),," ",1),
dCol,TEXTSPLIT(    REPT(TEXTJOIN(" ",,REPT(d&" ",ec*fc)),ac*bc*cc ),," ",1),
eCol,TEXTSPLIT(    REPT(TEXTJOIN(" ",,REPT(e&" ",fc)),ac*bc*cc*dc ),," ",1),
fCol,TEXTSPLIT(    REPT(TEXTJOIN(" ",,REPT(f&" ",1)),ac*bc*cc*dc*ec ),," ",1),
SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(TEXTSPLIT(TEXTJOIN("-",,aCol&","&bCol&","&cCol&","&dCol&","&eCol&","&fCol),"-"),",@,",","),",@",""),"@,",""),"@",""))