Spreadsheet: 840188d1692541433-transforming-database-with-formulas-transforming-database-with-formula
Sheet: Starting Base

 | This is the original database, I need to transform this with formula or power query or somethong to result like: [NAME]
 | in [NAME] | some information is simplified..
 | Date | Account | General ledger account | Mapped | Creditor number | SO/PO | Our ref. | VAT code | Transaction:Subtype | Your reference | Description | Cost unit | Currency code | Debit | Credit | Amount | Amount in DC | Project | Cost centre | Fulfilment date | General ledger transactions: free field 2 | Doc. date | Item group | Entry number | Selection code | Item | Description:Item | Type | General ledger transactions: free field 1 | General ledger transactions: free field 3 | General ledger transactions: free field 4 | General ledger transactions: free field 5 | Quantity | Sales order debtor | Classification | Created by | Modified by | Package of origin of transaction | Search code statistical system | Search code transaction A | Transport method search code | Search code city of loading/unloading | Unique posting number | Debtor number
1 Transaction | 2022-01-01 00:00:00 | AeroConnections | 148000 | Trade and other receivables | 4162 |  | 20003686 | 0 | Other | AC121020M | Offset entry |  | USD | 0 | 26121.69 | -8100 | -26121.69 |  | 100 |  |  | 2022-01-01 00:00:00 |  | 24320016 |  |  |  | Creditor account |  |  | 0 | 0 | 0 |  |  | [NAME] | [NAME] | Transaction originates from matching |  |  |  |  | 1220000499
1 Transaction | 2022-01-01 00:00:00 | AeroConnections | 311000 | Trade and other payables | 4162 |  | 20003686 | 0 | Other | AC121020M | Offset entry |  | USD | 26121.69 | 0 | 8100 | 26121.69 |  | 100 |  |  | 2022-01-01 00:00:00 |  | 24320016 |  |  |  | Creditor account |  |  | 0 | 0 | 0 |  |  | [NAME] | [NAME] | Transaction originates from matching |  |  |  |  | 1220000499
2 Transaction | 2022-01-01 00:00:00 | AeroConnections | 148000 | Trade and other receivables | 4162 |  | 20004159 | 0 | Other | INV AC-10220 | Offset entry |  | USD | 0 | 5159.84 | -1600 | -5159.84 |  | 600 |  |  | 2022-01-01 00:00:00 |  | 24320017 |  |  |  | Creditor account |  |  | 0 | 0 | 0 |  |  | [NAME] | [NAME] | Transaction originates from matching |  |  |  |  | 1220000501
2 Transaction | 2022-01-01 00:00:00 | AeroConnections | 311000 | Trade and other payables | 4162 |  | 20004159 | 0 | Other | INV AC-10220 | Offset entry |  | USD | 5159.84 | 0 | 1600 | 5159.84 |  | 600 |  |  | 2022-01-01 00:00:00 |  | 24320017 |  |  |  | Creditor account |  |  | 0 | 0 | 0 |  |  | [NAME] | [NAME] | Transaction originates from matching |  |  |  |  | 1220000501
3 Transaction | 2022-01-01 00:00:00 | Unknown | 746000 | General and administrative expenses |  |  | 10009597 | 0 | Depreciation | ა/ფ ეა-72 7944925,ელ0599623125 | Depreciation |  | GEL | 0.6 | 0 | 0.6 | 0.6 |  | 001CC001 | 1/1/2022 |  | 2022-01-01 00:00:00 | 10 | 31023166 |  | FA7000 | ავეჯი და სხვა ინვენტარი | Expense account |  |  | 0 | 0 | 1 |  |  | [NAME] | [NAME] | Transaction originates from E-Assets |  |  |  |  | 1220003912
3 Transaction | 2022-01-01 00:00:00 | Unknown | 227000 | Plant and equipment |  |  | 10009597 | 0 | Depreciation | ა/ფ ეა-72 7944925,ელ0599623125 | Depreciation |  | GEL | 0 | 0.6 | -0.6 | -0.6 |  | 001CC001 | 1/1/2022 |  | 2022-01-01 00:00:00 | 10 | 31023166 |  | FA7000 | ავეჯი და სხვა ინვენტარი | Asset account |  |  | 0 | 0 | 1 |  |  | [NAME] | [NAME] | Transaction originates from E-Assets |  |  |  |  | 1220003912