Transpose

What I have                                                       What I need (by formula)

       C      D        E       F       G                       H            I           J

3  serial   Boy   Boy    Boy    Girl   Girl            Serial       Boy      Girl

4   1         10    23                35     5            1              10

5   2         7                          18                   1             23

6                                                                1                           35

7                                                                1                           5

8                                                               2                7

9                                                               2                            18

Thanks

 

By: Emad

Leave a Reply

Your email address will not be published. Required fields are marked *