SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

declare @emp table(id int identity(1,1),E_Name varchar(20),E_company varchar(20),Emp_Val VARCHAR(10))
insert into @emp(E_Name,E_company,Emp_Val)VALUES('Rahim','WELLS','A')
insert into @emp(E_Name,E_company,Emp_Val)VALUES('Jag','collebra',NULL)
insert into @emp(E_Name,E_company,Emp_Val)VALUES('Vasu','nunet',NULL)
insert into @emp(E_Name,E_company,Emp_Val)VALUES('Kiran','crystal',NULL)
insert into @emp(E_Name,E_company,Emp_Val)VALUES('Sajan','tiato',NULL)

insert into @emp(E_Name,E_company,Emp_Val)VALUES('RAM','WELLS','A')
insert into @emp(E_Name,E_company,Emp_Val)VALUES('Srinu','Cognizant','B')
insert into @emp(E_Name,E_company,Emp_Val)VALUES('Raju','Cognizant','B')

select max(case when e_company = 'WELLS' then e_name end) as wells,
       max(case when e_company = 'Cognizant' then e_name end) as cognizant,
       max(case when e_company not in ('WELLS', 'Cognizant') then e_name end) as nulls       
from (select e.*,
             row_number() over (partition by (case when e_company in ('WELLS', 'Cognizant') then e_company end) order by id) as seqnum
      from @emp e
     ) e
group by seqnum
order by seqnum;

wells	cognizant	nulls
Rahim	Srinu	Jag
RAM	Raju	Vasu
null	null	Kiran
null	null	Sajan

Warning: Null value is eliminated by an aggregate or other SET operation.

id	E_Name	E_company	Emp_Val	seqnum
2	Jag	collebra	null	1
3	Vasu	nunet	null	2
4	Kiran	crystal	null	3
5	Sajan	tiato	null	4
7	Srinu	Cognizant	B	1
8	Raju	Cognizant	B	2
1	Rahim	WELLS	A	1
6	RAM	WELLS	A	2