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!