Copy from one list to another in different time scales. Confusing?

  • Thread starter Thread starter gaga.kaplan
  • Start date Start date
G

gaga.kaplan

Would anyone know what type of code to use so that it copies 1981q1
into Jan 1981, Feb 1981, Apr 1981 and then moves on to 1981q2 and
copies the value there to paste it into Apr 1981, May 1981, and Jun
1981....
This goes on till 2050 and it is a pain to continue doing this.


column A are the numbers 111, 222, 333....
Column B are the months-year
Column C are the numbers that are copied from Column F
Column D is blank
Column E are the years and quarters
Column F is the GDP in that quarter.

1 Jan-1981 5,307.5 1981q1 5,307.5
1 Feb-1981 5,307.5 1981q2 5,266.1
1 Mar-1981 5,307.5 1981q3 5,329.8
2 Apr-1981 5,266.1 1981q4 5,263.4
2 May-1981 5,266.1 1982q1 5,177.1
2 Jun-1981 5,266.1 1982q2 5,204.9
3 Jul-1981 1982q3 5,185.2
3 Aug-1981 1982q4 5,189.8
3 Sep-1981 1983q1 5,253.8
4 Oct-1981 1983q2 5,372.3
4 Nov-1981 1983q3 5,478.4
4 Dec-1981 1983q4 5,590.5
5 Jan-1982 1984q1 5,699.8
5 Feb-1982 1984q2 5,797.9
5 Mar-1982 1984q3 5,854.3
6 Apr-1982 1984q4 5,902.4
 
Would anyone know what type of code to use so that it copies 1981q1
into Jan 1981, Feb 1981, Apr 1981 and then moves on to 1981q2 and
copies the value there to paste it into Apr 1981, May 1981, and Jun
1981....
This goes on till 2050 and it is a pain to continue doing this.

column A are the numbers 111, 222, 333....
Column B are the months-year
Column C are the numbers that are copied from Column F
Column D is blank
Column E are the years and quarters
Column F is the GDP in that quarter.

1 Jan-1981 5,307.5 1981q1 5,307.5
1 Feb-1981 5,307.5 1981q2 5,266.1
1 Mar-1981 5,307.5 1981q3 5,329.8
2 Apr-1981 5,266.1 1981q4 5,263.4
2 May-1981 5,266.1 1982q1 5,177.1
2 Jun-1981 5,266.1 1982q2 5,204.9
3 Jul-1981 1982q3 5,185.2
3 Aug-1981 1982q4 5,189.8
3 Sep-1981 1983q1 5,253.8
4 Oct-1981 1983q2 5,372.3
4 Nov-1981 1983q3 5,478.4
4 Dec-1981 1983q4 5,590.5
5 Jan-1982 1984q1 5,699.8
5 Feb-1982 1984q2 5,797.9
5 Mar-1982 1984q3 5,854.3
6 Apr-1982 1984q4 5,902.4

If the pattern doesn't change and if it starts in row 1 then try...

=INDIRECT("F" & A1)

If there are heading in row 1 and the data starts in row 2 then try...

=INDIRECT("F" & A1+1)

Ken Johnson
 
Another thought ..

Assume data as posted in row1 down

Put in C1: =OFFSET($F$1,INT((ROWS($1:1)-1)/3),)
Copy down as far as required to return the GDP figs from col F
in the desired manner, viz:

5307.5
5307.5
5307.5
5266.1
5266.1
5266.1
5329.8
5329.8
5329.8
etc
 
Back
Top