About Prince Andrew "being in despair" regarding his lack of inheritance. [View all]

Depends on how one regards the situation. Yes, the Queen did it for tax reasons. But the Queen meted out a huge chunk of change for Andrew during her lifetime, including a royal payout to settle an embarrassing legal controversy regarding a minor (Jeffery Epstein) and her son. In estate law, that could be called an "Advancement," meaning that Andrew got his share before the Queen's death. He could have spent the money any way he wanted, including investing, but he didn't.