Need to Convert 5 Row String of Data to 6 Rows in Excel 2007

[alcharbonneau]

Hi

The attached excerpt is from a worksheet containing revenue and expenses of multiple organizations. The organizations are required to report revenues, expenses, profit(loss) additional revenue, additional expenses, and total profit(loss), representing 6 rows in the spread sheet. Some organizations do not have additional expenses in line 03000 so they report in 5 rows. I need all of the organizations to report in 6 rows so I have manually edited the worksheet using =COUNTIF(B:B,B2)=6 in column G. When this edit returns FALSE, I insert a 0 in the appropriate row (see line 12). I then perform the second edit checking to see if the numbers add correctly (column H). I would like a formula that automates this process so that when I drag down column G, it identifies (1) organizations with 5 rows of data (2) inserts a row for line 03000 (3) places a 0 in column F and (4) duplicates the record number (column A) and organization (column B).

Thanks in advance for considering/responding to this request.

Al