I have the attached spreadsheet with two columns: column A (award) and column B (name). I need the data to be transposed to Name in column A, Award 1 in column B, Award 2 in column C, etc. Copy/transpose won't work because of the repeated names. I know this is a simple pivot thing but I cannot figure it out. Help, wise ones! Thanks! Susanna
<colgroup><col><col></colgroup><tbody>
</tbody>
Award | Name |
NHS Honor Collar | Abraham, Noah |
SNHS Honor Cord | Abraham, Noah |
SNHS Honor Cord | Abraham, Noah |
NHS Honor Collar | Abraham, Noelle |
SNHS Honor Cord | Abraham, Noelle |
YES Medal | Abraham, Noelle |
<colgroup><col><col></colgroup><tbody>
</tbody>