Spreadsheet: 874453d1721052532-extracting-data-from-excell-table-in-alphabetically-order-income_expense
Sheet: Sheet1

 | I'm requesting excel formula to produce a framework of Profit and Loss Account using data from Income_Expense table as shown on desired solution
 | Please note that the profit and loss details are arranged in alphabetically order.
 |  |  |  |  | Desired Solution
 | Account Name | Group |  |  | Income
 | Accountant Fees owing | Current liabilities |  |  | Bus Fares
 | Accounting fees | Expense |  |  | Collegiate projects
 | Accounts payable | Current liabilities |  |  | Exam Fees
 | Accounts receivable | Current assets |  |  | Fees
 | Accrued expenses | Current liabilities |  |  | Sundry Income
 | Accumulated funds | Equity |  |  | Total Income
 | Advertising | Expense |  |  | Expenses
 | Allowance for doubtful debts account | Current assets |  |  | Accounting fees
 | AuditIng fees | Expense |  |  | Advertising
 | Bad debt expense | Expense |  |  | AuditIng fees
 | Bank Account US$ | Current assets |  |  | Bad debt expense
 | Bank Account ZWL | Current assets |  |  | Bank Charges
 | Bank Charges | Expense |  |  | Cleaning
 | Bonds payable | Long-term liabilities |  |  | Clothing costs
 | Buildings @ Cost | Long term assets |  |  | Collegiate projects Expenses
 | Bus Fares | Income |  |  | Currency charges
 | CBZ Bank- COLLEGIATE:  [PHONE] | Current assets |  |  | Depreciation
 | Cleaning | Expense |  |  | Donations
 | Clothing costs | Expense |  |  | Electricity
 | Collegiate projects | Income |  |  | Entertainment
 | Collegiate projects Expenses | Expense |  |  | Equipment depreciation
 | Currency charges | Expense |  |  | Equipment hire
 | Sundry Income | Income |  |  | Equipment maintenance | Expense
 | Depreciation | Expense |  |  | Expenses
 | Discounts taken | Cost of sales |  |  | Feeding Programme
 | Donations | Expense |  |  | Fuel & Oil
 | Electricity | Expense |  |  | Funeral
 | Entertainment | Expense |  |  | Insurance
 | Equipment @ Cost | Long term assets |  |  | Intellectal property amortization
 | Equipment Accum depreciation | Long term assets |  |  | Interest expense
 | Equipment depreciation | Expense |  |  | Knight frank
 | Equipment hire | Expense |  |  | Legal fees
 | Equipment maintenance | Expense |  |  | Licenses
 | Exam Fees | Income |  |  | Marketing expenses
 | Feeding Programme | Expense |  |  | Mispostings account
 | Fees | Income |  |  | NEC
 | Finished goods | Current assets |  |  | NSSA
 | Fuel & Oil | Expense |  |  | Total Expenses
 | Funeral | Expense |  |  | Profit / (Loss)
 | Furniture @ Cost | Long term assets
 | Furniture Accum Depreciation | Long term assets
 | Gifts & samples | Expense
 | Income tax payable | Current liabilities
 | Insurance | Expense
 | Intellectal property amortization | Expense
 | Interest expense | Expense
 | Interest payable | Current liabilities
 | Knight frank | Expense
 | Legal fees | Expense
 | Licenses | Expense
 | Loan | Long-term liabilities
 | Long term marketable securities | Long term assets
 | Marketing expenses | Expense
 | Mispostings account | Expense
 | Motor Vehicle @ Cost | Long term assets
 | Motor Vehicle Accum depreciation | Long term assets
 | NEC | Expense
 | Net Surplus / (Deficit) for the year | Equity
 | Net Surplus / (Deficit) for the year | Equity
 | Notes payable | Current liabilities
 | NSSA | Expense
 | Other receivables | Current assets
 | Other savings account | Current assets