I have a spreadsheet as a .xls generated from a swimming carnival program.
It gives me data in column A that looks like:
<tbody>
</tbody>
I want it to look like: (there could be up to 8 events for each student):
<tbody>
</tbody>
Then the data can be mail merged to a parent letter.
How can I make Excel do this?
I want it to be able to be reused year after year.
It gives me data in column A that looks like:
Appleby, Esmae - Female - Year: 7 - Comp#: - T - DOB: 14/03/2003 |
#73 Girls 12 100 Free Secondary |
Bonnyville Sarah - Female - Year: 7 - Comp#: - T - DOB: 11/03/2003 |
#13 Girls 12 50 Free Secondary |
#35 Girls 12 50 Fly Secondary |
#73 Girls 12 100 Free Secondary |
Capper Allison - Female - Year: 7 - Comp#: - C - DOB: 16/01/2003 |
#13 Girls 12 50 Free Secondary |
#57 Girls 12 50 Breast Secondary |
Floss Chantelle - Female - Year: 7 - Comp#: - C - DOB: 20/01/2003 |
#13 Girls 12 50 Free Secondary |
#57 Girls 12 50 Breast Secondary |
#73 Girls 12 100 Free Secondary |
#87 Girls 12 50 Back Secondary |
Frost, Jack - Male - Year: 7 - Comp#: 285 - C - DOB: 29/01/2003 |
#4 Boys 12-14 200 IM Secondary |
#21 Boys 12 50 Free Secondary |
#43 Boys 12 50 Fly Secondary |
#54 Boys 12-14 200 Free Secondary |
#65 Boys 12 50 Breast Secondary |
#80 Boys 12 100 Free Secondary |
#95 Boys 12 50 Back Secondary |
<tbody>
</tbody>
I want it to look like: (there could be up to 8 events for each student):
Appleby, Esmae - Female - Year: 7 - Comp#: - T - DOB: 14/03/2003 | #73 Girls 12 100 Free Secondary | ||||||
Bonnyville Sarah - Female - Year: 7 - Comp#: - T - DOB: 11/03/2003 | #13 Girls 12 50 Free Secondary | #35 Girls 12 50 Fly Secondary | #73 Girls 12 100 Free Secondary | ||||
Capper Allison - Female - Year: 7 - Comp#: - C - DOB: 16/01/2003 | #13 Girls 12 50 Free Secondary | #57 Girls 12 50 Breast Secondary | |||||
Floss Chantelle - Female - Year: 7 - Comp#: - C - DOB: 20/01/2003 | #13 Girls 12 50 Free Secondary | #57 Girls 12 50 Breast Secondary | #73 Girls 12 100 Free Secondary | #87 Girls 12 50 Back Secondary | |||
Frost, Jack - Male - Year: 7 - Comp#: 285 - C - DOB: 29/01/2003 | #4 Boys 12-14 200 IM Secondary | #21 Boys 12 50 Free Secondary | #43 Boys 12 50 Fly Secondary | #54 Boys 12-14 200 Free Secondary | #65 Boys 12 50 Breast Secondary | #80 Boys 12 100 Free Secondary | #95 Boys 12 50 Back Secondary |
<tbody>
</tbody>
Then the data can be mail merged to a parent letter.
How can I make Excel do this?
I want it to be able to be reused year after year.