Combine pairs of duplicate rows while totalling dollar values for each pair

[macc2001]

Hi all

I have a finance system report which is exporting around 15 columns of data. Each employee has two rows of data per person. The names and all 9 text value columns are duplicated across each pair of rows.

Each pair of rows is derived from two buckets of financial information and 6 of the 15 columns contains different dollar value on every row.

I want to consolidate the pairs in excel so there is only one record per employee, but the 6 currency fields need to be added together to give a total for each employee.

Any thoughts on how to approach this? Thanks

 

[Joe4]

Welcome to the Board!

In cases like this, it often very helpful if you could show us some sample data and your expected output (just be sure to remove any sensitive data first).
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.