fill time seiries to plot

[hcacote]

Hi,

I have several series that have the following Year-Quarter versus
Value eg:

Serie1
2008-Q1 1
2008-Q3 2
2009-Q1 5

Serie2
2007-Q4 55
2008-Q3 1
2009-Q1 11

How can I manipulate the data in order to obtain something that I can
later plot eg:

Serie1 Serie2
2007-Q4 0 55
2008-Q1 1 0
2008-Q2 0 0
2008-Q3 2 1
2008-Q4 0 0
2009-Q1 5 11

I am bit lost on how can I have data in a format that I can later
plot.

Thank you, best regards
Hugo

 

[Bernard Liengme]

1) I have your Serie1 in A1:A5 (label in A1, data starts in row 2)
2) In E1:E8 I have
2007-Q4
2008-Q1
2008-Q2
2008-Q3
2008-Q4
2009-Q1

3) In F1 I have
=IF(ISNA(VLOOKUP(E2,$A$2:$B$4,2,FALSE)),"",VLOOKUP(E2,$A$2:$B$4,2,FALSE))
Copy down to E8

4) Use similar formula in G1 on Serie2 data
best wishes