I know this question might have been asked many times, but I failed to find them. My original table is like this

```
    Location Language Component Score
    A        Eng         1        25
    A        Eng         2        30
    B        Eng         1        12
    B        Eng         2        50

```

Expected Output:

```
    Location Language  Score1    Score2
    A        Eng         25       30
    B        Eng         12       50

```

Thanks!