Spreadsheet: 856123d1705490355-how-to-automatically-update-formula-if-there-is-no-table-update-array-formula-automatically-aligw
Sheet: Sheet1

Data |  |  |  |  |  |  |  |  |  |  |  | Help |  |  |  | Help
1st Level | 2nd Level | 3rd Level | 4th Level | 5th Level | 6th Level | 7th Level | 8th Level | 9th Level | 10th Level | 11th Level |  | 1st Level | 2nd Level |  |  | 2nd Level | 3rd Level |  |  | FILTER(tbl_Data,tbl_Data[#Headers]=M2) |  | REDUCE("",M3#,LAMBDA(z,y,HSTACK(z,FILTER(b,ay))))
Alaric | Blackthoon | Percival | Thornfield | Thorne | Emberstone | Orion | Nightfall | Vesper | Nightshade | Jasper |  |  |  |  |  |  |  |  |  |  |  |  | Blackthoon | Stormrider | [NAME] | [NAME] | Frost | Blackthorn | Wilder | [NAME] | Phoenix | Fox | Frost | Creedsong | Stormwhisper
Asher | Stormrider | Thalia | Nightshade | [NAME] | Starlight | Isadora | Frostbloom | Bastian | Stormwatch | [NAME] |  | Asher | Stormrider |  |  | Blackthorn | [NAME] |  |  | Asher |  | #N/A | #N/A | #N/A | #N/A | #N/A | Frostwood | #N/A | #N/A | #N/A | #N/A | Nightshade | Nightshade | Crowe | #N/A
Astrid | [NAME] | Verity | Blaise | Victor | Storm | Odalys | Silvermoon | Peregrine | Storm | Twilight |  | Astrid | [NAME] |  |  | Creedsong | Odessa |  |  | Astrid
[NAME] | [NAME] | Xander | Eclipsesong | Nightshade | Orion | Augustus | Peregrine | Frost | [NAME] | Isadora |  | [NAME] | [NAME] |  |  | Crowe | Amara |  |  | [NAME] |  | DROP(REDUCE("",M3#,LAMBDA(z,y,HSTACK(z,FILTER(b,ay)))),,1)
Atticus | Frost | Maximilian | Ravenwood | Zephyr | Hawthorne | Odalys | Silvermoon | Peregrine | Storm | Leopold |  | Atticus | Frost | Frostwood |  | Fox | Seraphim |  |  | Atticus |  |  | Stormrider | [NAME] | [NAME] | Frost | Blackthorn | Wilder | [NAME] | Phoenix | Fox | Frost | Creedsong | Stormwhisper
Atticus | Frostwood | Isolde | Frostwood | Thorne | Blackthorn | Isolde | Ravenwood | Twilightwhisper | Nightingale | Valerian |  | Augustus | Blackthorn |  |  | Frost | Maximilian | [NAME] |  | Atticus |  | #N/A | #N/A | #N/A | #N/A | Frostwood | #N/A | #N/A | #N/A | #N/A | Nightshade | Nightshade | Crowe | #N/A
Augustus | Blackthorn | [NAME] | [NAME] | Seraphina | Nova | Xander | Winter | Sapphira | Iliad | Odalys |  | Bastian | Wilder |  |  | Frostwood | Isolde |  |  | Augustus
Bastian | Wilder | Vesper | Frost | Lysandra | Frost | [NAME] | Phoenix | Zephyrine | Starwhisper | Hawkmoon |  | Blackthorn | [NAME] |  |  | [NAME] | Xander |  |  | Bastian |  | IFERROR(DROP(REDUCE("",Q3#,LAMBDA(z,y,HSTACK(z,FILTER(b,a=y)))),,1),"")
Blackthorn | [NAME] | Shadow | [NAME] | Nova | Cassius | Frost | Orion | Shadow | Seraphina | Everhart |  | Briar | Phoenix |  |  | [NAME] | Shadow |  |  | Blackthorn |  |  | Stormrider | [NAME] | [NAME] | Frost | Blackthorn | Wilder | [NAME] | Phoenix | Fox | Frost | Creedsong | Stormwhisper
Briar | Phoenix | Thorne | Twilight | Odessa | Obsidian | Lysandra | Frost | Frost | Moonwhisper | Lysandra |  | Calista | Fox | Nightshade |  | [NAME] | Verity |  |  | Briar |  |  |  |  |  | Frostwood |  |  |  |  | Nightshade | Nightshade | Crowe
Calista | Fox | Seraphim | Stardust | Thorne | [NAME] | Evangeline | Frost | Sapphira | Winters | [NAME] |  | Calypso | Frost | Nightshade |  | Nightshade | [NAME] | Briar |  | Calista
Calista | Nightshade | [NAME] | Hawkmoon | Thistle | Skywhisper | Amara | Quillon | Shadow | [NAME] | [NAME] |  | [NAME] | Creedsong | Crowe |  | Phoenix | Thorne |  |  | Calista |  | TRANSPOSE(IFERROR(DROP(REDUCE("",M3#,LAMBDA(z,y,HSTACK(z,FILTER(b,a=y)))),,1),""))
Calypso | Frost | [NAME] | Frost | Quillon | Shadow | Xander | Nightshade | Cassiopeia | Frostfire | Moonstone |  | Caspian | Stormwhisper |  |  | Stormrider | Thalia |  |  | Calypso
Calypso | Nightshade | Briar | Obsidian | [NAME] | Rosewood | Orion | Emberstorm | Crowesong | Frost | Eclipse |  |  |  |  |  | Stormwhisper | Orion |  |  | Calypso |  | Stormrider
[NAME] | Creedsong | Odessa | Frost | Storm | Zephyrine | Caspian | Asher | [NAME] | [NAME] | Seraphina |  |  |  |  |  | Wilder | Vesper |  |  | [NAME] |  | [NAME]
[NAME] | Crowe | Amara | Creed | Bastian | Rain | Orion | [NAME] | [NAME] | Twilightwhisper | [NAME] |  |  |  |  |  |  |  |  |  | [NAME] |  | [NAME]
Caspian | Stormwhisper | Orion | Frostwhisper | Winter | Veridian | Thorne | Octavia | Frost | [NAME] | Odessa |  |  |  |  |  |  |  |  |  | Caspian |  | Frost | Frostwood
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blackthorn
Dropdown |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FILTER(tbl_Data,tbl_Data[#Headers]=2) |  | Wilder
1st Level | 2nd Level | 3rd Level | 4th Level | 5th Level | 6th Level | 7th Level | 8th Level | 9th Level | 10th Level | 11th Level |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stormrider |  | Phoenix
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Fox | Nightshade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  | Frost | Nightshade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Frost |  | Creedsong | Crowe
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Frostwood |  | Stormwhisper
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blackthorn
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wilder
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Phoenix
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fox
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nightshade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Frost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nightshade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Creedsong
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Crowe
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Stormwhisper