You can split cells into columns in Excel using the "Text to Columns" tool, which is a great way to organize lots of data.

Sometimes the current Microsoft Excel data structure doesn’t match requirements of other users and software. Learn how to combine columnar values into a single cell using Microsoft Excel’s ...

Use cells within the balance column as well to create balance-column amounts following the same procedure.

Open your income and expenses Excel worksheet. Select an empty cell beneath the last item in your "income" column. Type "Total Income" in this cell, then press the "Enter" key.