Code:
SELECT [_ID], [G-STAFF], DIVISION, [_Content Type], [1st] AS Data, 1 AS Dy, [_Workflow Instance ID], [_File Type], [_URL Path], [_Path], [_Item Type], [Created By], [Modified By], Modified, Created, [_Encoded Absolute URL] FROM [PerStat v1]
UNION SELECT [_ID], [G-STAFF], DIVISION, [_Content Type], [2nd], 2, [_Workflow Instance ID], [_File Type], [_URL Path], [_Path], [_Item Type], [Created By], [Modified By], Modified, Created, [_Encoded Absolute URL] FROM [PerStat v1]
UNION SELECT [_ID], [G-STAFF], DIVISION, [_Content Type], [3rd], 3, [_Workflow Instance ID], [_File Type], [_URL Path], [_Path], [_Item Type], [Created By], [Modified By], Modified, Created, [_Encoded Absolute URL] FROM [PerStat v1]
UNION SELECT [_ID], [G-STAFF], DIVISION, [_Content Type], [4th], 4, [_Workflow Instance ID], [_File Type], [_URL Path], [_Path], [_Item Type], [Created By], [Modified By], Modified, Created, [_Encoded Absolute URL] FROM [PerStat v1]
UNION SELECT [_ID], [G-STAFF], DIVISION, [_Content Type], [5th], 5, [_Workflow Instance ID], [_File Type], [_URL Path], [_Path], [_Item Type], [Created By], [Modified By], Modified, Created, [_Encoded Absolute URL] FROM [PerStat v1]
UNION SELECT [_ID], [G-STAFF], DIVISION, [_Content Type], [6th], 6, [_Workflow Instance ID], [_File Type], [_URL Path], [_Path], [_Item Type], [Created By], [Modified By], Modified, Created, [_Encoded Absolute URL] FROM [PerStat v1]
UNION SELECT [_ID], [G-STAFF], DIVISION, [_Content Type], [7th], 7, [_Workflow Instance ID], [_File Type], [_URL Path], [_Path], [_Item Type], [Created By], [Modified By], Modified, Created, [_Encoded Absolute URL] FROM [PerStat v1]
UNION SELECT [_ID], [G-STAFF], DIVISION, [_Content Type], [8th], 8, [_Workflow Instance ID], [_File Type], [_URL Path], [_Path], [_Item Type], [Created By], [Modified By], Modified, Created, [_Encoded Absolute URL] FROM [PerStat v1];