I have a payments file (BACS file) that is a CSV file. The file contains
payments to payees containing name, account details and values. Most of the
time each line is unique but occasionally there may be two or more payments
to the same payee on consequtive lines (they are always together) the values
may be the same on each line or not. What I want to do is to end up with only
one line per payee with the total of the lines if there are more than one.
I've tried using pivot tables and this works however I then need to export
the file back out a CSV file again. In summary therefore I am trying to use
Excel to consolidate payment lines to the same payee in a CSV file when more
than one line exists for a payee. Maybe I'm using the wrong application to do
this?

Hello Steve,

As you have the pivot table written, and assuming it contains the
information you want, why not just copy and paste from it?

Good luck

"Steve Derrick" wrote:

I have a payments file (BACS file) that is a CSV file. The file contains
payments to payees containing name, account details and values. Most of the
time each line is unique but occasionally there may be two or more payments
to the same payee on consequtive lines (they are always together) the values
may be the same on each line or not. What I want to do is to end up with only
one line per payee with the total of the lines if there are more than one.
I've tried using pivot tables and this works however I then need to export
the file back out a CSV file again. In summary therefore I am trying to use
Excel to consolidate payment lines to the same payee in a CSV file when more
than one line exists for a payee. Maybe I'm using the wrong application to do
this?