Hi,

Can anyone help me to solve my problem ?

I have some data table in the following format....

ID Contract Ver. Value

1 BlahBlahBlah 0 A1 B1 Open 100

2 BlahBlahBlah 0 A2 B1 Open 150

3 BlahBlahBlah 0 A2 B2 Open 50

4 BlahBlahBlah 1 A1 B1 Open 100

5 BlahBlahBlah 1 A2 B2 Open 75

6 BlahBlahBlah 2 A1 B1 Open 100

7 OupsOups 0 C1 B1 Open 1500

8 OupsOups 0 A2 B1 Open 150

9 OupsOups 0 A2 B2 Open 50

10 OupsOups 1 C1 B1 Open 125

11 OupsOups 1 A2 B2 Open 75

and i want somehow to obtain the following format:

ID Contract Ver. Value

BlahBlahBlah 0 A1 B1 Open 100

BlahBlahBlah 0 A2 B1 Open 150

BlahBlahBlah 0 A2 B2 Open 50

BlahBlahBlah 1 A1 B1 Open 125

BlahBlahBlah 1 A2 B2 Open 75

**BlahBlahBlah 1 A2 B1 Open 0**

BlahBlahBlah 2 A1 B1 Open 100

**BlahBlahBlah 2 A2 B1 Open 0**

**BlahBlahBlah 2 A2 B2 Open 0**

OupsOups 0 C1 B1 Open 1500

OupsOups 0 A2 B1 Open 150

OupsOups 0 A2 B2 Open 50

OupsOups 1 C1 B1 Open 125

OupsOups 1 A2 B2 Open 75

**OupsOups 1 A2 B1 Open 0**

I want to insert to every version of a contract data rows that are missing from the 0's version of the same contract with 0 as value.