Spreadsheet: 780887d1652855451-can-i-combine-multiple-array-formulas-into-1-combine-dynamic-arrays
Sheet: Sheet1

Below is what I have now |  |  |  | Here is what I'd like to have:
 | 32 | [NAME] for Cat3 |  | Cat3 | Person3 | 32 |  |  | Person3 | 32 |  |  | Person3 | 32
Person17 | 20.84 |  |  | Cat3 | Person17 | 20.84 |  | Cat3 | Person17 | 20.84 |  | Cat5 | Person4 | 20
Person31 | 32 |  |  | Cat3 | Person31 | 32 |  | Cat3 | Person31 | 32 |  | Cat5 | Person5 | 30
 |  |  |  | Cat4 | Person70 | 187.22 |  | Cat4 | Person70 | 187.22 |  | Cat5 | Person7 | 40
 |  |  |  | Cat4 | Person78 | 287.91 |  | Cat4 | Person78 | 287.91 |  | Cat3 | Person17 | 20.84
 | 187.22 | [NAME] for Cat4 |  | Cat4 | Person79 | 146.79 |  | Cat4 | Person79 | 146.79 |  | Cat3 | Person31 | 32
Person78 | 287.91 |  |  | Cat4 | Person92 | 415.38 |  | Cat4 | Person92 | 415.38 |  | Cat4 | Person70 | 187.22
Person79 | 146.79 |  |  | Cat5 | Person4 | 20 |  | Cat5 | Person4 | 20 |  | Cat4 | Person78 | 287.91
Person92 | 415.38 |  |  | Cat5 | Person5 | 30 |  | Cat5 | Person5 | 30 |  | Cat4 | Person79 | 146.79
 |  |  |  | Cat5 | Person7 | 40 |  | Cat5 | Person7 | 40 |  | Cat4 | Person92 | 415.38
 | 20 | [NAME] for Cat5 |  |  | Person1 | 10 |  |  | Person1 | 10
Person5 | 30 |  |  | Cat1 | Person2 | 13 |  | Cat2 | Person1 | 96.57
Person7 | 40 |  |  | Cat1 | Person4 | 10 |  | Cat1 | Person2 | 13
 |  |  |  | Cat1 | Person6 | 10 |  | Cat2 | Person2 | 18.54
 |  |  |  | Cat1 | Person14 | 13 |  | Cat2 | Person3 | 187.13
 |  |  |  | Cat1 | Person15 | 13 |  | Cat3 | Person3 | 32
 |  |  |  | Cat1 | Person16 | 13 |  | Cat1 | Person4 | 10
 |  |  |  | Cat1 | Person21 | 10 |  | Cat2 | Person4 | 61.7
 |  |  |  | Cat1 | Person22 | 10 |  | Cat5 | Person4 | 20
 |  |  |  | Cat1 | Person24 | 10 |  | Cat5 | Person5 | 30
 |  |  |  | Cat1 | Person28 | 10 |  | Cat1 | Person6 | 10
 |  |  |  | Cat1 | Person30 | 13 |  | Cat5 | Person7 | 40
 |  |  |  | Cat1 | Person31 | 10 |  | Cat2 | Person9 | 148.13
 |  |  |  | Cat1 | Person32 | 13 |  | Cat2 | Person10 | 58.85
 |  |  |  | Cat1 | Person34 | 13 |  | Cat2 | Person12 | 135.8
 |  |  |  | Cat1 | Person38 | 13 |  | Cat2 | [NAME] | 181.88
 |  |  |  | Cat1 | Person42 | 13 |  | Cat1 | Person14 | 13
 |  |  |  | Cat1 | Person43 | 13 |  | Cat2 | Person14 | 10.5
 |  |  |  | Cat1 | Person44 | 13 |  | Cat1 | Person15 | 13
 |  |  |  | Cat1 | Person45 | 13 |  | Cat1 | Person16 | 13
 |  |  |  | Cat1 | Person46 | 13 |  | Cat2 | Person17 | 346.96
 |  |  |  | Cat1 | Person59 | 13 |  | Cat3 | Person17 | 20.84
 |  |  |  | Cat1 | Person61 | 13 |  | Cat1 | Person21 | 10
 |  |  |  | Cat1 | Person63 | 13 |  | Cat1 | Person22 | 10
 |  |  |  | Cat1 | Person64 | 13 |  | Cat1 | Person24 | 10
 |  |  |  | Cat1 | Person65 | 13 |  | Cat2 | Person24 | 18.13
 |  |  |  | Cat1 | Person70 | 13 |  | Cat2 | Person25 | 142.45
 |  |  |  | Cat1 | Person74 | 13 |  | Cat1 | Person28 | 10
 |  |  |  | Cat1 | Person75 | 13 |  | Cat1 | Person30 | 13
 |  |  |  | Cat1 | Person76 | 13 |  | Cat1 | Person31 | 10
 |  |  |  | Cat1 | Person78 | 13 |  | Cat2 | Person31 | 132.47
 |  |  |  | Cat1 | Person81 | 13 |  | Cat3 | Person31 | 32
 |  |  |  | Cat1 | Person82 | 13 |  | Cat1 | Person32 | 13
 |  |  |  | Cat1 | Person83 | 13 |  | Cat2 | Person32 | 132.47
 |  |  |  | Cat1 | Person84 | 13 |  | Cat1 | Person34 | 13
 |  |  |  | Cat1 | Person85 | 13 |  | Cat2 | Person35 | 78.65
 |  |  |  | Cat1 | Person89 | 13 |  | Cat2 | Person37 | 197.73
 |  |  |  | Cat1 | Person90 | 13 |  | Cat1 | Person38 | 13
 |  |  |  | Cat1 | Person92 | 13 |  | Cat1 | Person42 | 13
 |  |  |  | Cat1 | Person96 | 13 |  | Cat1 | Person43 | 13
 |  |  |  | Cat1 | Person99 | 13 |  | Cat1 | Person44 | 13
 |  |  |  | Cat1 | Person100 | 13 |  | Cat1 | Person45 | 13
 |  |  |  | Cat1 | Person105 | 13 |  | Cat2 | Person45 | 58.37
 |  |  |  | Cat1 | Person106 | 13 |  | Cat1 | Person46 | 13
 |  |  |  | Cat1 | Person107 | 13 |  | Cat2 | Person46 | 208.26
 |  |  |  | Cat1 | Person108 | 13 |  | Cat1 | Person59 | 13
 |  |  |  | Cat1 | Person109 | 10 |  | Cat1 | Person61 | 13
 |  |  |  | Cat1 | Person110 | 13 |  | Cat1 | Person63 | 13
 |  |  |  | Cat1 | Person114 | 13 |  | Cat2 | Person63 | 132.47
 |  |  |  | Cat1 | Person115 | 13 |  | Cat1 | Person64 | 13
 |  |  |  | Cat1 | Person116 | 13 |  | Cat1 | Person65 | 13
 |  |  |  | Cat1 | Person117 | 13 |  | Cat1 | Person70 | 13
 |  |  |  | Cat1 | Person125 | 13 |  | Cat2 | Person70 | 101.63
 |  |  |  | Cat1 | Person126 | 13 |  | Cat4 | Person70 | 187.22
 |  |  |  | Cat1 | Person128 | 13 |  | Cat1 | Person74 | 13
 |  |  |  | Cat1 | Person129 | 13 |  | Cat1 | Person75 | 13
 |  |  |  | Cat1 | Person131 | 13 |  | Cat1 | Person76 | 13
 |  |  |  | Cat2 | Person1 | 96.57000000000001 |  | Cat1 | Person78 | 13
 |  |  |  | Cat2 | Person2 | 18.54 |  | Cat2 | Person78 | 185.28
 |  |  |  | Cat2 | Person3 | 187.13 |  | Cat4 | Person78 | 287.91
 |  |  |  | Cat2 | Person4 | 61.7 |  | Cat4 | Person79 | 146.79
 |  |  |  | Cat2 | Person9 | 148.13 |  | Cat1 | Person81 | 13
 |  |  |  | Cat2 | Person10 | 58.85 |  | Cat1 | Person82 | 13
 |  |  |  | Cat2 | Person12 | 135.8 |  | Cat1 | Person83 | 13
 |  |  |  | Cat2 | [NAME] | 181.88 |  | Cat1 | Person84 | 13
 |  |  |  | Cat2 | Person14 | 10.5 |  | Cat1 | Person85 | 13
 |  |  |  | Cat2 | Person17 | 346.96 |  | Cat2 | Person85 | 93.24
 |  |  |  | Cat2 | Person24 | 18.13 |  | Cat1 | Person89 | 13
 |  |  |  | Cat2 | Person25 | 142.45 |  | Cat1 | Person90 | 13
 |  |  |  | Cat2 | Person31 | 132.47 |  | Cat1 | Person92 | 13
 |  |  |  | Cat2 | Person32 | 132.47 |  | Cat2 | Person92 | 135.8
 |  |  |  | Cat2 | Person35 | 78.65 |  | Cat4 | Person92 | 415.38
 |  |  |  | Cat2 | Person37 | 197.73 |  | Cat1 | Person96 | 13
 |  |  |  | Cat2 | Person45 | 58.37 |  | Cat1 | Person99 | 13
 |  |  |  | Cat2 | Person46 | 208.26 |  | Cat2 | Person99 | 52.69
 |  |  |  | Cat2 | Person63 | 132.47 |  | Cat1 | Person100 | 13
 |  |  |  | Cat2 | Person70 | 101.63 |  | Cat2 | Person100 | 257.48
 |  |  |  | Cat2 | Person78 | 185.28 |  | Cat1 | Person105 | 13
 |  |  |  | Cat2 | Person85 | 93.24000000000001 |  | Cat2 | Person105 | 58.37
 |  |  |  | Cat2 | Person92 | 135.8 |  | Cat1 | Person106 | 13
 |  |  |  | Cat2 | Person99 | 52.69 |  | Cat1 | Person107 | 13
 |  |  |  | Cat2 | Person100 | 257.48 |  | Cat1 | Person108 | 13
 |  |  |  | Cat2 | Person105 | 58.37 |  | Cat1 | Person109 | 10
 |  |  |  | Cat2 | Person109 | 78.65 |  | Cat2 | Person109 | 78.65
 |  |  |  | Cat2 | Person116 | 70.82 |  | Cat1 | Person110 | 13
 |  |  |  | Cat3 | Person3 | 32 |  | Cat1 | Person114 | 13
 |  |  |  | Cat3 | Person17 | 20.84 |  | Cat1 | Person115 | 13
 |  |  |  | Cat3 | Person31 | 32 |  | Cat1 | Person116 | 13
 |  |  |  | Cat4 | Person70 | 187.22 |  | Cat2 | Person116 | 70.82
 |  |  |  | Cat4 | Person78 | 287.91 |  | Cat1 | Person117 | 13
 |  |  |  | Cat4 | Person79 | 146.79 |  | Cat1 | Person125 | 13
 |  |  |  | Cat4 | Person92 | 415.38 |  | Cat1 | Person126 | 13
 |  |  |  | Cat5 | Person4 | 20 |  | Cat1 | Person128 | 13
 |  |  |  | Cat5 | Person5 | 30 |  | Cat1 | Person129 | 13
 |  |  |  | Cat5 | Person7 | 40 |  | Cat1 | Person131 | 13