I have attached a sample excel workbook with two tabs on how my input is and how the output should be. Please, I would really appreciate whatever response you guys can give. Please, see screen shot of it also below
You need to structure your input data correctly first since one cannot identify which balance column is for which car. Also, what do the rows indicate? Are they the daily balances or monthly balances? Unless you have your data correctly first, one cannot suggest an appropriate solution for your problem.