Hi,
I have a spreadsheet that lists a number of locations that containers have been imported to or exported from. The problem is that the people who supplied the data have enterend numerous rows for similar locations, for example:
Yeovil 1 3 4
Yeovil, Somerset 0 2 2
Yeovil - Somerset 7 1 8
I am looking for a way to get all the Yeovil data into 1 row, so it looks like this:
Yeovil 8 6 14
The spreadhseet is >4000 rows long, so with MANY duplicates, so I'm after a simple way to tweak this data.
Cheers,
Adam
Adam F
Solaris System Administrator
I have a spreadsheet that lists a number of locations that containers have been imported to or exported from. The problem is that the people who supplied the data have enterend numerous rows for similar locations, for example:
Yeovil 1 3 4
Yeovil, Somerset 0 2 2
Yeovil - Somerset 7 1 8
I am looking for a way to get all the Yeovil data into 1 row, so it looks like this:
Yeovil 8 6 14
The spreadhseet is >4000 rows long, so with MANY duplicates, so I'm after a simple way to tweak this data.
Cheers,
Adam
Adam F
Solaris System Administrator