Excel 2010 :: How To Approach A Schedule K-1 For QC

I finally found a program that can out put the amounts from a schedule k-1 form. Now comes the hard part, adding logical formulas.

Some of the line items either have an amount to or not. What the pdf2xl program does is output where if the line item has an amount to it, it would add the amount right below the line item. If it doesn't have an amount, it would just add the next line item underneath. Question is what is a good approach to get this to automate, so if line items have an amount, then that amount is known to be line item cell above. Here comes the tricky part as well, some line items have alphabets to them, so a particular line item say 11 would have A-F or line 13 would have A-W. What is a good way to have the line item output the line item + alphabet?

Column A & C = Line Item
Column B & D = Alphabet

Link to the IRS form [URL] .........

Excel 2010
A
B
C
D

1
1
Ordinary business income (loss)
15
Credits

[Code]....