Hi - please could someone help me - I am trying to sum a field for all
unique values in another column e.g.

James 5
James 11
Jack 1
Tim 99
and so on with variable names

My output needs to be something like:

James 16 + data from any of the other fields that were in
the original worksheet
Jack 1
Tim 99

Cheers for any input,
Will