fill time seiries to plot


H

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
 
Ad

Advertisements

B

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top