MS Access - create queries in current database

1. Create transform query of income variation type rows to columns, add columns and reconcile to total income value. See draft layout in mock query (qryTransform income) Table (NZ Benchmarks 2016 Filtered) with 6,666 rows
2. Similar for 1 but for expenses. See draft layout in mock query (qryTransform Expense)
See variable codes summary in query (qryNZ Variables List Filtered)
3. For given variable codes and columns, table (NZ Benchmarks 2016 Filtered) , multiply values by 1000 and store.

Please express interest and capabilities, and i will forward database to selected shortlist.