H
Holly Bodger
I am trying to find an automated way of summing common row
data. For example:
ORIGINAL DATA
Row1 123 John Smith
Row2 456 John Smith
Row3 678 John Smith
Row4 324 Dave Jones
Row5 678 Dave Jones
DESIRED DATA
Row1 1257 John Smith
Row2 1002 Dave Jones
I have several thousand rows and don't want to write
something that is specific to the data that appears in the
second column.
Any ideas?
data. For example:
ORIGINAL DATA
Row1 123 John Smith
Row2 456 John Smith
Row3 678 John Smith
Row4 324 Dave Jones
Row5 678 Dave Jones
DESIRED DATA
Row1 1257 John Smith
Row2 1002 Dave Jones
I have several thousand rows and don't want to write
something that is specific to the data that appears in the
second column.
Any ideas?