Spreadsheet: 873594d1720102999-unpivot-via-formula-from-dynamic-array-output-unpivot-columns-via-formula
Sheet: Sheet1

 | FY25 |  |  |  |  |  |  |  |  | Desired Output Result in Dynamic Array
 | Q1 |  |  |  | Q2
 | 45444 | 45474 | 45505 | Q1FY25 Total | 45536 | 45566 | 45597 | Q2FY25 Total |  | Statement | Fiscal | Quarter | Date | Category | Amount |  | Fiscal | Quarter | Date | Category | Amount
P.O's | 5 | 2 | 0 | 7 | 3 | 3 | 3 | 9 |  | Forecast | FY25 | Q1 | 45444 | P.O's | 5 | Forecast | FY25 | Q1 | 45444 | P.O's | 5
Overheads | 1 | 1 | 1 | 3 | 2 | 2 | 2 | 6 |  | Forecast | FY25 | Q1 | 45474 | P.O's | 2 | Forecast | FY25 | Q1 | 45474 | P.O's | 2
Revenues | 15 | 35 | 45 | 95 | 30 | 40 | 50 | 120 |  | Forecast | FY25 | Q1 | 45505 | P.O's | 0 | Forecast | FY25 | Q1 | 45505 | P.O's | 0
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q1 | Q1FY25 Total | P.O's | 7 | Forecast | FY25 | Q1 | Q1FY25 Total | P.O's | 7
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | 45536 | P.O's | 3 | Forecast | FY25 | Q2 | 45536 | P.O's | 3
 |  |  | Dynamic Array |  |  |  |  |  |  | Forecast | FY25 | Q2 | 45566 | P.O's | 3 | Forecast | FY25 | Q2 | 45566 | P.O's | 3
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | 45597 | P.O's | 3 | Forecast | FY25 | Q2 | 45597 | P.O's | 3
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | Q2FY25 Total | P.O's | 9 | Forecast | FY25 | Q2 | Q2FY25 Total | P.O's | 9
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q1 | 45444 | Overheads | 1 | Forecast | FY25 | Q1 | 45444 | Overheads | 1
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q1 | 45474 | Overheads | 1 | Forecast | FY25 | Q1 | 45474 | Overheads | 1
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q1 | 45505 | Overheads | 1 | Forecast | FY25 | Q1 | 45505 | Overheads | 1
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q1 | Q1FY25 Total | Overheads | 3 | Forecast | FY25 | Q1 | Q1FY25 Total | Overheads | 3
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | 45536 | Overheads | 2 | Forecast | FY25 | Q2 | 45536 | Overheads | 2
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | 45566 | Overheads | 2 | Forecast | FY25 | Q2 | 45566 | Overheads | 2
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | 45597 | Overheads | 2 | Forecast | FY25 | Q2 | 45597 | Overheads | 2
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | Q2FY25 Total | Overheads | 6 | Forecast | FY25 | Q2 | Q2FY25 Total | Overheads | 6
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q1 | 45444 | Revenues | 15 | Forecast | FY25 | Q1 | 45444 | Revenues | 15
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q1 | 45474 | Revenues | 35 | Forecast | FY25 | Q1 | 45474 | Revenues | 35
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q1 | 45505 | Revenues | 45 | Forecast | FY25 | Q1 | 45505 | Revenues | 45
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q1 | Q1FY25 Total | Revenues | 95 | Forecast | FY25 | Q1 | Q1FY25 Total | Revenues | 95
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | 45536 | Revenues | 30 | Forecast | FY25 | Q2 | 45536 | Revenues | 30
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | 45566 | Revenues | 40 | Forecast | FY25 | Q2 | 45566 | Revenues | 40
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | 45597 | Revenues | 50 | Forecast | FY25 | Q2 | 45597 | Revenues | 50
 |  |  |  |  |  |  |  |  |  | Forecast | FY25 | Q2 | Q2FY25 Total | Revenues | 120 | Forecast | FY25 | Q2 | Q2FY25 Total | Revenues | 120