excelfan14
New Member
- Joined
- Apr 6, 2018
- Messages
- 3
I wonder if any of you can help me. I have a large amount of data taking up over 1000 rows. The data is for entrants results across 4 events (columns C, D, E and F). Sometimes an entrant will take part in 2 or more of the events. Each event they take part in is shown in a separate row. What I would like to do is have each entrant with the same name consolidated into just one row while keeping the event data under the correct column. What I could do if it helps is concatenate the first and surname (ie Column A and B) into just one column.
Below is an example:
<tbody>
</tbody>
Below is an example:
<tbody> </tbody> | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<tbody>
</tbody>
Last edited by a moderator: