Convert Column data to Row

SELECT t1.cus_id,t1.code1,t1.code1_desc,t2.code2,t2.code2_desc,t3.code3,t3.code3_desc
FROM TableA t1
INNER JOIN TableA t2 ON t1.cus_id=t2.cus_id AND t2.code1='c2'
INNER JOIN TableA t3 ON t2.cus_id=t3.cus_id AND t3.code1='c3'
WHERE t1.code1='c1'

DECLARE @tbl AS TABLE(cus_id INT,code1 VARCHAR(10),code1_desc VARCHAR(20),code2 VARCHAR(10),code2_desc VARCHAR(20),code3 VARCHAR(10),code3_desc VARCHAR(20))

INSERT INTO @tbl
SELECT 1 cus_id,'c1' code1,'xxx' code1_desc,'c1' code2,'xxx' code2_desc, 'c1' code3 ,'xxx' code3_desc
UNION ALL
SELECT 1, 'c2', 'yyy', 'c2', 'yyy', 'c2', 'yyy'
UNION ALL
SELECT 1, 'c3', 'zzz', 'c3', 'zzz', 'c3', 'zzz'
UNION ALL
SELECT 2, 'c1', 'xxx', 'c1', 'xxx', 'c1', 'xxx'
UNION ALL
SELECT 2, 'c2', 'yyy', 'c2', 'yyy', 'c2', 'yyy'
UNION ALL
SELECT 2, 'c3', 'zzz', 'c3', 'zzz', 'c3', 'zzz'

--select * from @tbl

SELECT t1.cus_id,t1.code1,t1.code1_desc,t2.code2,t2.code2_desc,t3.code3,t3.code3_desc
FROM @tbl t1
INNER JOIN @tbl t2 ON t1.cus_id=t2.cus_id and t2.code1='c2'
INNER JOIN @tbl t3 ON t2.cus_id=t3.cus_id and t3.code1='c3'
WHERE t1.code1='c1'