Need vertical table as horizontal table in SQL

SQLServerCentral » Latest topics

Need vertical table as horizontal table in SQL

Hi Team,

can you please help me to get
create table company
(
name varchar(100)
)

insert into company
select 'IBM'
UNION ALL
select 'Goolge'
UNION ALL
select 'Microsoft'
UNION ALL
select 'app

more info...