historical-rate-sheet---Janaury-2021.xlsx
Table 1 FIXED RATES OF THE PAST 25 YEARS AVERAGE RESIDENTIAL MORTGAGE LENDING RATE – 5 YEAR Year,January,February,March,April,May,June,July,August,September,October,November,December,Average 1996,8.02%,7.79%,8.16%,8.48%,8.47%,8.48%,8.48%,8.07%,7.94%,7.50%,7.01%,6.94%,7.95% 1997,7.14%,7.12%,7.06%...
docs.google.com
so i manually have the dates in a vertical row (eg in column P, starting row 3, i have jan 96, cell p4 is feb 96, p5 is march 96, etc.) ...then i used this formula in Q3 (=OFFSET($B$3,0,ROW()-3,1,1)) and dragged it down so that horizontal data is now vertifcal
this is too manual since for the year 1997, i need to manually change the formula again (in Q15, I have =OFFSET($B$4,0,ROW()-15,1,1))
perhaps a macro that loops would be better? e.g., copy b3:m3 , paste to q3 (year 1996)...then copy b4:m4, paste to q15 (year 1997) ...my VBA isnt good enough to write this..help!