Combine multiple cells

  • I want to Generate 2 separate CSV files which Contains information as available in (Result for Bank) and (Result for CSV) sheet of the attached file

    The Main Source data is available in Salaries Sheet

    For Bank Sheet

    Date will be 27th of every month; and Date Identifier is 1

    Debit Account Number is Fixed,

    Amount column is the Net Salary

    BEN.name is the name of Employee BEN.ACCT is the BANK ACCOUNT

    BEN. REFERENCE is the Month name

    BEN. SORT. CODE will be lookup from Bank Codes Sheet

    BEN. BANK is the name of bank of employee


    For CSV Sheet

    Phone# is the first column and Agent will be 2nd column and Third column will these

    Name "your salary for" Month "is" BASIC 35000 PHONE 5000 GROSS 40000 "Payee" 1300 NET 38700

    The above salary details part will contain information if the amount is available in the heading

    for example, if the phone amount is available then it will show in the message

    The deduction sum will be shown as Payee in the message

    So the Leaves Arrears Phone Bonus OverT payee have amount then they will be the part of the message otherwise not.

    I am sure you expert will help me in this regard