Check for a cell value change

[Wills1971]

Hi All,

I have a spreadsheet that contains peoples names in a column and different values associated to the person in another column e.g.
Wright 1.5
Wright 3
Wright 4.2
Wright 7
Jones 4.6
Jones 2.1
Wilson 9
Wilson 6.7
Wilson 1
Wilson 3.2
Wilson 5

I want to be able to read the name in the column copy it and also copy the associated values for the name and paste them in to a row on another worksheet. Then repeat the process for each name in the column. So I end up with e.g.

Wright 1.5 3 4.2 7
Jones 4.6 2.1
Wilson 9 6.7 1 3.2 5

Many thanks in advance
Will

 

[MickG]

You're welcome