Sum and Merge matching rows into single row

[spectraflame]

I have a CSV file that varies in length. The request is to have a macro to import the CSV file, sort it by account number (COL A) and for every row that has a like number in COL A, sum the numeric values in COL F. I have considered a pivot table however we then have to take the SUMMED records and export then in CSV.

Any ideas on how to SUM based on COL A? The rest of the information in each like row is duplicated.

 

[spectraflame]

Can a pivot table include other data related to the account number? Meaning the original rows of data include customer related information like address etc. Can that information be included in the pivot table as text in the same row as the account number?