SQL Server 2017

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

create table customer_question_responses (
  id int identity primary key, 
  cust_id int not null, 
  question_no int not null, 
  response varchar(30)
)
insert into customer_question_responses
(cust_id, question_no, response) values
  (1234, 	1, 	'YES') 
, (1234, 	2, 	'NO') 
, (1234, 	3, 	'TAKEN') 
, (1234, 	4, 	'NOT GIVEN') 
, (4567, 	1, 	'NO') 
, (4567, 	3, 	'NOT TAKEN') 
, (8888, 	2, 	'YES') 
, (8888, 	4, 	'GIVEN') 
8 rows affected

SELECT *
FROM
(
    SELECT 
      cust_id
    , [col] = CONCAT('response_', 
                     row_number() over (partition by cust_id 
                                        order by question_no))
    , concat(response, null) as [value]
    FROM customer_question_responses
    UNION ALL
    SELECT 
      cust_id
    , [col] = CONCAT('question_', 
                     row_number() over (partition by cust_id 
                                        order by question_no))
    , concat(question_no, null) as [value]
    FROM customer_question_responses
) Src
PIVOT
(
  MAX([value]) 
  FOR [Col] IN (
   [question_1], [response_1], 
   [question_2], [response_2], 
   [question_3], [response_3], 
   [question_4], [response_4]
  ) 
) Pvt
ORDER BY cust_id


cust_id
question_1
response_1
question_2
response_2
question_3
response_3
question_4
response_4


1234
1
YES
2
NO
3
TAKEN
4
NOT GIVEN

4567
1
NO
3
NOT TAKEN
null
null
null
null

8888
2
YES
4
GIVEN
null
null
null
null

cust_id	question_1	response_1	question_2	response_2	question_3	response_3	question_4	response_4
1234	1	YES	2	NO	3	TAKEN	4	NOT GIVEN
4567	1	NO	3	NOT TAKEN	null	null	null	null
8888	2	YES	4	GIVEN	null	null	null	null