Spreadsheet: 65279d1265969382-concatenate-if-sample-v2
Sheet: Sheet1

 |  |  |  | Desired result
210000 | 100032874 | 210000      Trade Debtors Billed               1170233 | 100032874  210000 Trade Debtors Billed 1170233
220009 | 100032874 | 220009      nirola Main Account Unreconciled Incoming. Inc.               1170233 | 100032874  220009 nirola Main Account Unreconciled Incoming. Inc. 1170233
113976 | 100032911 | 113976    IRISH PERMANENT FINANCE    300000      Trade Creditors               1170233 | 100032911  113976 IRISH PERMANENT FINANCE 300000 Trade Creditors 1170233
220001 | 100032911 | 220001      nirola Main Account EFT Outgoing               1170233 | 100032911  220001 nirola Main Account EFT Outgoing 1170233
113976 | 100032912 | 113976    IRISH PERMANENT FINANCE    300000      Trade Creditors               1170233 | 100032912  113976 IRISH PERMANENT FINANCE 300000 Trade Creditors 1170233
220001 | 100032912 | 220001      nirola Main Account EFT Outgoing               1170233
113976 | 100032913 | 113976    IRISH PERMANENT FINANCE    300000      Trade Creditors               1170233 | 100032913  113976 IRISH PERMANENT FINANCE 300000 Trade Creditors 1170233 | 113976    IRISH PERMANENT FINANCE    300000      Trade Creditors               1170233            220001      nirola Main Account EFT Outgoing               1170233
220001 | 100032913 | 220001      nirola Main Account EFT Outgoing               1170233
113976 | 100032914 | 113976    IRISH PERMANENT FINANCE    300000      Trade Creditors               1170233 | 100032914  113976 IRISH PERMANENT FINANCE 300000 Trade Creditors 1170233 | 113976    IRISH PERMANENT FINANCE    300000      Trade Creditors               1170233            220001      nirola Main Account EFT Outgoing               1170233
220001 | 100032914 | 220001      nirola Main Account EFT Outgoing               1170233
113787 | 100032915 | 113787    AN POST    300000      Trade Creditors               1170233 | 100032915  113787 AN POST 300000 Trade Creditors 1170233 | 113787    AN POST    300000      Trade Creditors               1170233            220001      nirola Main Account EFT Outgoing               1170233
220001 | 100032915 | 220001      nirola Main Account EFT Outgoing               1170233
118547 | 100032916 | 118547    EAZY PASS    300000      Trade Creditors               1170233 | 100032916  118547 EAZY PASS 300000 Trade Creditors 1170233 | 118547    EAZY PASS    300000      Trade Creditors               1170233            220001      nirola Main Account EFT Outgoing               1170233
220001 | 100032916 | 220001      nirola Main Account EFT Outgoing               1170233
115263 | 100032917 | 115263    O2    300000      Trade Creditors               1170233 | 100032917  115263 O2 300000 Trade Creditors 1170233 | 115263    O2    300000      Trade Creditors               1170233            220001      nirola Main Account EFT Outgoing               1170233
220001 | 100032917 | 220001      nirola Main Account EFT Outgoing               1170233
113976 | 100032918 | 113976    IRISH PERMANENT FINANCE    300000      Trade Creditors               1170233 | 100032918  113976 IRISH PERMANENT FINANCE 300000 Trade Creditors 1170233 | 113976    IRISH PERMANENT FINANCE    300000      Trade Creditors               1170233            220001      nirola Main Account EFT Outgoing               1170233
220001 | 100032918 | 220001      nirola Main Account EFT Outgoing               1170233
305010 | 100032919 | 305010      Payroll Taxes               1170002 | 100032919  305010 Payroll Taxes 1170002 | 305010      Payroll Taxes               1170002            305010      Payroll Taxes               1170003            305010      Payroll Taxes               1170003            305010      Payroll Taxes               1170004            305010      Payroll Taxes               1170005            305010      Payroll Taxes               1170006            305010      Payroll Taxes               1170007            305010      Payroll Taxes               1170008            305010      Payroll Taxes               1170010            305010      Payroll Taxes               1170011            305010      Payroll Taxes               1170015            305010      Payroll Taxes               1170016
305010 | 100032919 | 305010      Payroll Taxes               1170003
305010 | 100032919 | 305010      Payroll Taxes               1170004
305010 | 100032919 | 305010      Payroll Taxes               1170005
305010 | 100032919 | 305010      Payroll Taxes               1170006
305010 | 100032919 | 305010      Payroll Taxes               1170007
305010 | 100032919 | 305010      Payroll Taxes               1170008
305010 | 100032919 | 305010      Payroll Taxes               1170010
305010 | 100032919 | 305010      Payroll Taxes               1170011
305010 | 100032919 | 305010      Payroll Taxes               1170015
305010 | 100032919 | 305010      Payroll Taxes               1170016