I want to convert column into rows in SharePoint 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.
Expand|Select|Wrap|Line Numbers
- 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
Please give me any solution on it
Thanks ,
Samadhan Kshirsagar