These steps will reformat the Individual Attempts survey report from D2L so that each Likert question statement is in a column instead of a row by creating a PivotTable in Excel.
Use a combination of filtering, flash fill, and formulas/functions to clean the data before creating a PivotTable. In cell A2, enter =B2 and in cell A3, enter =IF(B3="",A2,B3)
A
Python script to pivot the data without using Excel can also be downloaded.