Furniture Retail Module 1	 Furniture Retail Module 2
Passed	                          Passed
Failed	                          Passed

How to display above data in following manner

ModuleName                      Result
Furniture Retail Module 1       Passed	
Furniture Retail Module 1       Failed
Furniture Retail Module 2       Passed
Furniture Retail Module 2       Passed

Kindly please suggest me on this.

declare @test table
(
[Furniture Retail Module 1] varchar(100),
[Furniture Retail Module 2] varchar(100)
)
insert @test
SELECT 'Passed','Passed' UNION ALL
SELECT 'Failed','Passed'

SELECT ModuleName,Result
FROM @test t
UNPIVOT ( Result FOR ModuleName IN ([Furniture Retail Module 1],[Furniture Retail Module 2]))u
ORDER BY ModuleName


output
-----------------------------------------------------------
ModuleName	                Result
-----------------------------------------------------------
Furniture Retail Module 1	Passed
Furniture Retail Module 1	Failed
Furniture Retail Module 2	Passed
Furniture Retail Module 2	Passed