I have a query that returns the results like this:

```
Location ID Location Code   Location Name   Division Code   sSourceCode Division Name   Business Unit Code  Business Unit Name
83806   D4009   Vanier Mitsubishi Fuso  SALES_01    SALES_01    Sales_01    SALES DEPARTMENT    Fuso Vehicle Sales Department
83806   D4009   Vanier Mitsubishi Fuso  Parts_A0    Parts_A0    Parts District A0   PARTS DEPARTMENT    Fuso Parts Department
83806   D4009   Vanier Mitsubishi Fuso  SERVICE_C1  SERVICE_C1  Service Division C1 SERVICE DEPARTMENT  Fuso Service Department

```

I want to have the results like this:

```
Location ID    Location Code    Location Name   Parts Division Code   Parts sSourceCode  Parts Division Name    Sales Division Code   Sales Division Name       Sales Business Unit Code    Sales Business Unit Name    Parts Business Unit Code    Parts Business Unit Name

```

So for each locationID I need only one row, with its respective parts/service/sales division/business unit Codes and Names showing up on the same row as separate columns....Not convinced I can do it with Pivoting, if possible can someone point me in the right direction or give me some examples of how this can be achieved.