Hi, suppose I have the following table: Company Year Cond1 Cond2 A 2006 23 44 A 2008 23 44 B 2007 1 2 B 2009 3 4 In the table above, there are some gaps: some years are missing for each company. But for company A, the conditions for both years 2006 and 2008 are the same, so what I would like to do is to add a new row for the company A for the year 2007 with the same conditions, but for company B remain as is because the conditions are different (so don't add year 2008 for B). The new table should be like this: Company Year Cond1 Cond2 A 2006 23 44 A 2007 23 44 A 2008 23 44 B 2007 1 2 B 2008 3 4 Thank you!
... View more