I have an Excel file. There are 20 variables that I need a separate column for. However, my Excel file has the 20 variables as 6 rows of 5 cells each with the last cell (30th) as empty. I need it to be 29 cells across.
The file attached has 69,082 rows with 6 columns. I need 11,347 rows with 29 columns.