https://lorakulas.blogspot.com/2022/04/google-sheets-flip-data-google-sheets.html
Google Sheets Flip Data - Google Sheets How Do I Flip And Reverse Data Using Arrays R Excel