在MS Access 2013中将列转换为行

你好，
我想在Access 2013中将列转换为行.
我已经尝试过使用数据透视/U n Pivot，但是仍然出现问题.

请参阅我在访问数据库中编写的以下命令.

Hello,
I want to convert column into rows in Access 2013.
I have tried by using pivot /U n Pivot , but still i have got n Issue.

please see the following Command I have written in access database.

SELECT [Case Number], [Author 1], [Author 2], [Author 3]
FROM 
(
SELECT [Case Number], [Author 1], [Author 2], [Author 3]
FROM [Gold Metadata]
) 
UNPIVOT
(Orders FOR [Gold Metadata] IN 
( [Author 1], [Author 2], [Author 3])
)AS unpvt;
GO

请给我任何解决方案

谢谢，
Samadhan Kshirsagar

Please give me any solution on it

Thanks ,
Samadhan Kshirsagar