Hi, I dont know how to describe in the subject but here is what I'm struggling now. So I have this big table (24 months average balance (see below sample) id |active_dt|avgbal_201804|avgbal_201805|.........|avgbal_201902
001| 201807| 5000| 5300|.........| 7000
002| 201901| 3200| 3000|.........| 4500 I need to get avgbal of 3 months before and 3 months after from the active_dt The new fields name are avgbal_minus3, avgbal_minus2, avgbal_minus1, avgbal_plus1, avgbal_plus2, avgbal_plus3 id 001 should have avgbal_minus3= take from avgbal_201804 avgbal_minus2= take from avgbal_201805 avgbal_minus1= take from avgbal_201806 avgbal_plus1= take from avgbal_201808 avgbal_plus2= take from avgbal_201809 avgbal_plus3= take from avgbal_201810 while id 002 will take from avgbal_201810, avgbal_201811, avgbal_201812 and avgbal_201902 (this id will have blank avgbal_plus2 and avgbal_plus3 since the data only up to February. The final table should look like below id |active_dt|avgbal_minus3|avgbal_minus2|avgbal_minus1|avgbal_plus1|avgbal_plus2|avgbal_plus3| 001| 201807| 5000| 5300| XXXX| XXXX| XXXX| XXXX| 002| 201901| XXXX| XXXX| XXXX| 4500| | | Please help Thanks
... View more