Create custom excel for cash flow analysis from data set

Dear, I have attached two excels. we need to customize it based on custom bank statement where it can read all the transactions and classify them into categories debt or income with its descriptions. Operating Activities Operating activities make up the day-to-day transactions, like buy products, purchasing inventory, paying rent, and paying operating expenses. This section of the statement is associated with the Current Assets and Current Liabilities sections of the Balance Sheet, as well as the Revenue and Expenses section of the Income Statement. Investing Activities Investing activities include buying and selling assets like property and equipment, lending money to others and collecting the principal, and buying/selling investment securities. This section of the statement is associated with the Long-Term Assets section of the balance sheet. Financing Activities Financing activities include borrowing from creditors and repaying loans, and collecting money from owners/investors, and payment of cash dividends. This section of the statement is associated with the Long-Term Liabilities and Owners'/Stockholders' Equity from the Balance Sheet. Prepare and analyze the cash flow statement to say that if you have the records of all the cash transactions, then the preparation can be done using the simple method of categorizing the receipts and payments into the categories like Loans, Electricity, Rent, Fuel, ​etc. The indirect method can be used to create the statement of cash flows from the information in the balance sheet and income statement.