Entering peer to peer lending returns - need to take 50% as is joint account

Looking for ideas on how to best enter in returns/losses for a peer-to-peer (Lending Club/Prosper) lending account that is jointly held by myself and my ex-wife.  It is used for college savings for one of our kids.

 

I can import from lending club but then I have hundreds of lines that I need to adjust to 50% of the amounts. (628 to be exact)

 I can get them into excel and manipulate there pretty easily with formulas but don't know how to get them into Turbotax from there.  I don't want to really import the data from lending club and then edit all 600+ lines so any ideas appreciated!