Spreadsheet: 65140d1265871986-concatenate-if-sample
Sheet: Sheet1

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