Consolidate data

[beckgolubows]

Hello,

I am trying to sum figures in column J for each member listed in column A. For example, add up all the balances for Joe Blogs and have them displayed in just one row with £211.84 rather than the three rows with different balances already displayed. 

Do I use the consolidation tool to do this? So far I've been able to do this but wherever I reference for the consolidated table to go, it does not display all the other information such as email addresses.

Many thanks, 

Beck 

[#2]

@beckgolubows 

Here's a quick approach... it's not the most elegant proposal solution, but it's a proposal solution :))

The proposal solution is in the attached file.

Hope I was able to help you with this proposal.

NikolinoDE

I know I don't know anything (Socrates)