Not sure if this is doable using sql alone or not, but here is the problem. I have a weird requirement that data needs to be displayed in columns so users can compare data quickly!

Here is what the result set looks like right now

```
CustomerID  Company     Active
001         ATT        Y
002         ATT        N
003         ATT        Y
001         VZ         Y
002         VZ         N
003         VZ         Y
001         TM         Y
002         TM         Y
003         TM         Y

```

Now this is how they want to see it

```
CustomerID  Company     Active      Company     Active      Company     Active
001        ATT         Y           VZ          Y            TM         Y
002        ATT         N           VZ          N            TM         Y
003        ATT         Y           VZ          Y            TM         Y

```

Assumptions:

* This could be a pretty long table,
that's why they want to see all
companies on one row, rather than
needing to scroll down to see if
active or not.
	+ Nummber of companies
	is between 1-3 in most cases

Any help is appreciated.

Thanks!