Transpose function - advanced

Hi all,

I am looking for some transpose function in excel that will help me get the below:

this is the data I have currently:

name score award
Anna 2 award 1
Luisa 6 award 2
Arlene 8 award 2
Angel 1 award 1


I wonna keep the names in teh first column but rearrange the secodn and third column to award 1 and award 2, so that the above looks like:

name award 1 award 2
Anna 1
Luisa 6
Arlene 8
Angel 1


Thanks in advance for the help

Hi Arlette,

Yes, this is my intention. thx.